Jlindsey00's avatar
Jlindsey00
Icon for Advocate I rankAdvocate I
2 years ago
Status:
Accepted

Error in SQL server SSL Certificate Connection Since February '24 Release

Since the Power BI Feb 2024 release, all of the reports in our workspaces have had this SSL error: "The server name provided does not match the server name on the SQL Server SSL certificate ... " Eve...
Gateways
Reports
deanj20's avatar
deanj20
Icon for Advocate I rankAdvocate I
2 years ago
Wanted to add that we received a fix from MS. We were getting "certificate chain not trusted" errors on servers for Power BI Reports that previosuly worked no issue, no change anywhere.


Documented here, search "PBI_SQL_TRUSTED_SERVERS": https://learn.microsoft.com/en-us/power-query/connectors/sql-server

Can confirm after 3 days of trial and error, adding this environment variable (PBI_SQL_TRUSTED_SERVERS) to "Environment variables for your account" with the problem server name did the trick. I did have to clear out the Connection data (File > Options and Settings > Data source settings - select DB and Clear Permissions). Then add the data source back.

Adding this to all the top Google hits to hopefully save others the pain.

Completed Ideas