Datamart Fail to connect to Azure SQL database

[mz_1122]

Trying create a new datamart connecting to Azure SQL database.

Created a few datamarts with the same source prior to this and its was up and running before today and now I'm getting this error message after completing the neccesary SQL connection settings when trying to create a new datamart.

Also I'm getting this error message to the existing datamart that i successfully created while attempting to edit query on the existing table:

Activity ID: 8ae93185-3a05-4120-7beb-4fec0f240e95
Request ID: 5f617ef5-2a70-4686-a6aa-a3e8f518efdb
Status code: 500
Error Code: OperationCanceled
Batch ID: ea654f54-7af4-48cb-8f4d-7d84ea4e1690@69990ba0-36cb-4816-963e-cc4447188e96$2023-03-29T15:18:03.2375860Z@7c33f565-6639-4937-b8f7-f9ecfa121317

Tried on dataflow instead of datamart with the same SQL connection, it was able to connect successfully.

Was there bug or service outage currently?

[Anonymous]

Hi @mz_1122 

Check to see if a firewall in Azure is blocking Power BI Desktop from accessing the database, you can refer to the following link.

Secure Access to Azure SQL Servers for Power BI - Developer Support (microsoft.com)

Create Power BI Connection to Azure SQL Database (mssqltips.com)

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mz_1122]

Hi @Anonymous 

Hmm, i was encountering this issue on the Power BI Service, specifically on Datamart, not on PBI Desktop thou.