Reply
iainmc_macca
New Member

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.Error] Microsoft SQL: Cannot open server "xxxxx.org.uk" requested by the login. Th login fialed"

 

No one else in the organisation is getting the error. Can anyone tell me why this might be or even better hoew to fix it. 

 

Thanks.

2 REPLIES 2
v-xinruzhu-msft
Community Support
Community Support

Hi @iainmc_macca 

Based on your infotmation, You need to check the following points:

1.If your login username is right, you can refer to the following link.

python - Cannot open server requested by the login - Stack Overflow

2.Make sure that you have configure the firewall in  Azure,  you can refer to the following link.

Fixing error "Cannot open server - - requested by the login. Client with IP address - - is not allow...

 

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.

 

AmiraBedh
Super User
Super User

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:

Troubleshooting connectivity issues and other errors with Azure SQL Database and Azure SQL Managed I... 

Database engine errors 

Azure SQL Database and Azure Synapse IP firewall rules 


Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696
avatar user

Helpful resources

Announcements
March PBI video - carousel

Power BI Monthly Update - March 2025

Check out the March 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)