Azure SQL - error while importing the bacpac file

Question

I am trying to import a bacpac file into the Azure SQL server, however the import is not happening and it is also not giving any explicit error in the process.

If I check under deployments in the resource group, it gives the below failure message:

Performs a database extension operation - Failed

Apart from this there is no explicit failure message that can indicate what went wrong. Also, "No Import/Export history is available" is coming under Import/Export history for the Azure SQL server.

Answer 1

From Microsoft document, There is certain limitation when you import database using BACPAC file.

• Elastic pool doesn't enable you to import databases.
• When Allow access to Azure services is set to OFF, Import-Export Service is unavailable.

As you are not getting what is exact error causing the problem, you can raise support ticket to Microsoft from here for more assistance on this.