This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowA new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.
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.
Hi @Anonymous
Hmm, i was encountering this issue on the Power BI Service, specifically on Datamart, not on PBI Desktop thou.
Check out the May 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 11 | |
| 10 | |
| 7 | |
| 7 | |
| 7 |
| User | Count |
|---|---|
| 28 | |
| 25 | |
| 22 | |
| 21 | |
| 21 |