SSL provider error while connecting to SQL server from Power BI

[Paramjit]

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 

[rgouette]

@raomohsin54  Legend x2
Helped in August, 2025

[RaoMohsin6054]

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

[Tredoux]

@RaoMohsin6054 Legend! Thanks for this.

[v-easonf-msft · Accepted solution]

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

[Paramjit]

Thank 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