Login to On-Premises SQL Server Instance.
Right Click the Databases Folder and select [Import Data-tier Application]
Choose Import from Windows Azure Storage
Provide the Storage Account information
Provide the temporary storage location for file to be downloaded.Provide the location which has enough space (.bacpac filesize + 10%)
Specify the target Database Name and file locations