Forum Discussion

sarah1212's avatar
sarah1212
New Member
3 years ago

Certificate Chain Issue

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 f...
Nick_Oetjen's avatar
Nick_Oetjen
New Member
2 years ago

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.