Forum Discussion
That_Analyst
4 years agoMicrosoft Employee
Cannot Open server, requested log in failed
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? ...
v-kkf-msft
4 years agoCommunity Support
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.