Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
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.
Hmm, i was encountering this issue on the Power BI Service, specifically on Datamart, not on PBI Desktop thou.