Error in reprot refresh

[anmolmalviya05]

I have a power bi report which use sql as data source, It's getting refreshed well in my machine but giving error in another machine on power bI desktop. Getting below error:

Details: "Microsoft SQL: A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted.)"

[Anonymous]

Hi @anmolmalviya05 

What is the version of Power BI Desktop installed on both machines? There are other users who have reported this issue on February 2024 or later versions of Power BI Desktop. Product team engineers are working to resolve this issue. SQL Connection - "0 - The certificate chain was i... - Microsoft Fabric Community

In the meantime, please try the methods in these links to see if you get relief:

https://learn.microsoft.com/en-us/power-query/connectors/sql-server#sql-server-certificate-isnt-trus... 

Resolving the SQL Server SSL Certificate Error in Power BI | by Mohsin Mukhtiar | Microsoft Power BI...

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

which gateway version are you using?

On-premises data gateway September 2024 Release | Microsoft Power BI Blog | Microsoft Power BI