Certificate Chain Issue

[sarah1212]

I am an employee of the Dept. of Veterans Affairs, so I am able to login to Power BI with my government login. I have put in the correct server information to pull data from a SQL server. I get the following information "We encountered an error while trying to connect. Details: "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.)""

[Nick_Oetjen]

Problem might occur from an outdated version of SQL Server, since v14 does not encrypt by default. Younger versions do, and it is possible to establish an encrypted communication for v14. However, this is not always easy to solve. PowerBI nowadays expects an encryption and lets the connection fail.

You might try to set up a ODBC-Connection, which accepts the way the SQL Server is configured: 

- run dialog box by pressing Windows+R and click OK

- Enter command odbcad32 , choose 64-Bit-Version , and press ENTER, then Add

- Select an appropriate Driver, at least "ODBC Driver 17 for SQL Server", not the Native Client (!). (Install if needed.)

- Work your way through. On the last page of setting, choose

That's it. In PowerBI / PowerQuery, use a new source for ODBC , not SQL Server.

Select the new ODBC-Connection and enter your credentials.

[josef78]

Ask our database administrator, how connect to this server. If you trying connect from Power BI Desktop,, probably, there are two options, you must install correct authority certificate, or you must turn off SLL in connection to SQL server.

[MattThomas]

Were you able to figure this out? I am having the same issue