Forum Discussion

Azam_'s avatar
Azam_
Regular Visitor
2 years ago

Certificate Chain Not Trusted Error affecting PBI only, can't switch credentials to Windows.

Hi, I'm getting the following error when connecting to a SQL server running on an Azure VM.   Microsoft SQL: A connection was successfully established with the server, but then an error occurred du...
Need Help
Azam_'s avatar
Azam_
Regular Visitor
2 years ago

I spoke to microsoft support and they told me it's an issue that they're aware of. A workaround can be found here:

https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trusted-on-the-client-power-bi-desktop-or-on-premises-data-gateway

However this did not work for me, but may be helpful to other people. Support couldn't confirm when the issue would be resolved but I'm hoping the March 2024 PowerBI desktop release fixes the issue.

Coffeehouse45's avatar
Coffeehouse45
Frequent Visitor
1 year ago

I implemented this workaround and my issue was resolved. I am using the on-prem data gateway for MS fabric SQL Server authentication connection. I installed the latest on-prem data gateway update.  I am using the April 2025 version of the on-prem data gateway. The version number is 3000.266.4.