Forum Discussion
SQL Server Named Pipes Provider, error: 40
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)
