Unable to connect Microsoft SQL Server to Power BI Desktop

[SathishReddy]

Hi Team,

I am trying to import data from MS SQL to Power BI Desktop but  i am getting an error like this,"Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"

When i use . or Localhost it's working, but only it doesn't work when i given a Server Name.

Can anyone help me with this?

Thanks.

[Shahfaisal · Accepted solution]

Try these:

https://community.powerbi.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-O...

https://learn.microsoft.com/en-us/troubleshoot/sql/connect/error-message-when-you-connect