Forum Discussion
Data Refresh Error - - [DataSource.Error] Microsoft SQL: Cannot open server
I have a user that is trying to refresh an excel sheet that has a power query building the data but when they click "Refresh All" under the "Data" menu they get following error: "[DataSource.Erro...
Verify that the account has permission to access the 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: