Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
71 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |