Forum Discussion

Vasco's avatar
Vasco
New Member
10 years ago
Solved

SQL Server Named Pipes Provider, error: 40

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 probl...
  • konstantinos's avatar
    konstantinos
    10 years ago

    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

     

Vasco's avatar
Vasco
New Member
10 years ago

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 

konstantinos's avatar
konstantinos
Memorable Member
10 years ago

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

 

  • Vasco's avatar
    Vasco
    New Member
    10 years ago

    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)