Skip to main content

Power BI

Needs Votes

Add 'trust server certificate' option to Power BI Desktop (similar to SSMS)

Vote (24) Share
Jochem van der Meer's profile image

Jochem van der Meer on 05 Jan 2021 13:47:22

Manually choosing to trust the server certificate is currently not an option in Power BI Desktop. This is actually possible in SSMS, allowing us to connect to our Azure SQL database using a private endpoint. In Power BI Desktop there's no similar setting to be adjusted.

Connecting to the database and authenticating with an Azure AD account (our desired end state) traps the user in an endless loop: Power BI throws an error saying that the server name doesn't match the certificate (which is to be expected). It suggests to continue using an unencrypted connection, but what we want is to continue while trusting the certificate. Clicking 'ok' to continue with an unencrypted connection logically fails, and the same error message pops up again and again.

Trusting the server certificate would allow us to expose our Azure SQL database to our users by authenticating with the Azure AD account and without manually adding their IP addresses to our firewalls. Please fix this!