Following are steps to export the backpac file from the SQL on premises databases:
Goto Local Database Properties >Select Task > Select Export Data-tier Application
Browse > Select local disk location to save backpack export file.
Advanced > Select Tables as per requirement
Faced multiple Error of elements which are not supported in Azure
Kept only those table are supported
Export completed successfully.