Forum Discussion
Datamart Fail to connect to Azure SQL database
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 messa...
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.