Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Trouble connecting to Azure sql.
Tried editing data source permissions from Data source settings.
Cleared permissions and re entered, Cleared cached, nothing worked.
What else can I try?
I'm able to use Azure SQL database without any problems. I've been using this datasource for months, but now I suddenly have log in issues. Will check the firewall rules again
I have same issue - SSMS is fine with it but PowerBI can't access it. I'm accessing it from Azure VM that's allowed in the firewall - ssms access proves that. Support says open firewall to Power BI? How the heck do you open a firewall to a program? What are they talking about?
Hi @That_Analyst ,
Please ensure that the account has permission to access the master database, and you have set up a firewall rule to allow Power BI Desktop to make a connection to Azure SQL.
For more information, please refer to:
Azure SQL Database and Azure Synapse IP firewall rules
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 41 | |
| 38 | |
| 36 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 128 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |