Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi Power BI Experts,
I have been using successfully Power BI Desktop connected to an Access Web App located in MS Cloud service.
Everything was running amazingly smoothly until now. The problem is when I try to refresh the data, I receive the following error message ( the text may not be 100% accurate as I am translating it from portuguese):
"Microsoft SQL: There was an error related with the network or specific to the instance when establishing the connection to Server. The server was not found or was not accessible. Verify the name of the instance is correct and the SQL Server is configured to allow remote connections.(provider: Named Pipes Provider, error: 40 - It was not possible to open a connection to the SQL Server)"
I have recently installed Windows 10 in my computer and this was one this difficulty started.
Do I need to install SQL Server on top of Windows 10? If yes, what version?
I have double-check the server name and the database name. I dont see any place to put the username and password.
Is there any other configuration I need to do?
Any help to overcome this difficulty will be very appreciated.
Thanks in advance,
Vasco from Sintra (Portugal)
Solved! Go to Solution.
Go to File -> Options & Settings -> Data Source settings. A window with all connections you have will appear. Select the SQL connection and at the bottom of the window click edit..Update the credentials.
Hope this is your problem
No you don't need to install SQL Server. It seems that something has changed and you can no longer connect to the DB (but I guess you know that). It may not be related to Power BI at all - you need to test it. Are you able (or even know how) to connect to the DB not using Power BI? I would try that first and see if you can connect.
MAllington, thank you for your help in delimiting the problem.
I have successfuly connect to the same DB via an Excel Sheet. Power BI Service (Online) is refreshing smoothly also.
The problem is restricted to Power BI Desktop.
Any further help to solve this issue will be really appreciated.
Thanks in advance,
Vasco
Go to File -> Options & Settings -> Data Source settings. A window with all connections you have will appear. Select the SQL connection and at the bottom of the window click edit..Update the credentials.
Hope this is your problem
Thank you Konstantinos.
After some struggle with the credentials (I was confusing database credentials with Windows credentials) all is working fine now 🙂
What a relief...
Kind regards from Sintra (Portugal)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |