Forum Discussion
Solved
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 conne...
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
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 article
RaoMohsin6054 Legend! Thanks for this.