- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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:
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

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
05-20-2024 02:36 AM | |||
10-25-2023 01:10 AM | |||
05-23-2024 09:19 AM | |||
03-14-2024 06:36 PM | |||
11-29-2023 02:26 AM |
User | Count |
---|---|
32 | |
18 | |
14 | |
11 | |
9 |