Forum Discussion
SSL provider error while connecting to SQL server from Power BI
Hello Team,
one of our user is getting SSL provider error "the certificate chain issued by authority that is not trusted" while connecting to SQL server from Powre BI.
But he is able to connect by passing the port number with server name.
It looks like it is system specific.
Do you have any suggestions so that we can solve this error.
Thank you,
Paramjit
Hi， Paramjit
Please switch the connection type from MSFT account to Windows.
For more details, please refer to thses same thread.
Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only
login-error-while-connecting-sql-database-through-power-bi
error-message-when-you-connect
Best Regards,
Community Support Team _ Eason
5 Replies
To resolve the SSL certificate error in Power BI, create an environment variable PBI_SQL_TRUSTED_SERVERS with your SQL Server's name, then restart Power BI. This bypasses the server name mismatch issue.
Refer to the articleRaoMohsin6054 Legend! Thanks for this.
Hi， Paramjit
Please switch the connection type from MSFT account to Windows.
For more details, please refer to thses same thread.
Certificate-Chain-Not-Trusted-Error-Effecting-PowerBI-Only
login-error-while-connecting-sql-database-through-power-bi
error-message-when-you-connect
Best Regards,
Community Support Team _ EasonThank you v-easonf-msft
Windows account worked for us..Also one thing we had to remove the global permissions and then we create a new connection.
Thank you,
Paramjit
raomohsin54 Legend x2
Helped in August, 2025
