Forum Discussion

jesse_james's avatar
jesse_james
Helper I
6 years ago

Azure SQL Server connection error on Power BI service

Hi, I have problem with connection with SQL Server. I can connect in Power BI Desktop and SSMS using SQL Basic Authentication but it doesn't work in Power BI Service. Error message:   "Failed to up...
Need Help
v-diye-msft's avatar
v-diye-msft
Community Support
6 years ago

Hi  jesse_james 

 

Did you try to clear the credentials under the data source setting and try again?

 

Are you able to connect to SQL Server from SQL Server Management Studio(SSMS)? Ensure that SSMS is installed on the same machine with Power BI Desktop.

Besides, please follow the instructions in the article below to troubleshoot this connection error.
https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/troubleshoot-connecting-to-th...

 

 

Also, here's similar solved thread could be your reference:

https://community.powerbi.com/t5/Desktop/Can-t-connect-to-SQL-Server-named-instance/m-p/308006 

 

 

 

  • jesse_james's avatar
    jesse_james
    Helper I
    6 years ago

    Hi, 

    yes I've just tried with cleared credientials- with the same error.

     

    I manage to log in via SSMS on the same machine like Power BI Desktop.

    I also tried to use other machine - still nothing.