SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted

[pthapa]

Hello all,

I have a dashboard published in power bi service that is failing refresh due to the following error. 
"SSL Provider, error: 0 - The certificate chain was issued by an authority that is not trusted"

Can someone please help how to resolve this.

I have tried the following troubleshoots:

In power bi desktop: Option, Data source and settings, Clear permissions, Edit Credentials, Close, Refresh Power BI file and publish.

After publishing, connect the gateway, turn on the refresh. Then Manually turn on the refresh, it fails with the error shown above.

Here is the actual screen shot from the PBI service.

Thanks for your time.

pthapa

[SaiTejaTalasila]

Hi @pthapa ,

Please refer this -

https://community.fabric.microsoft.com/t5/Power-Query/Certificate-Chain-Not-Trusted-Error-Effecting-...

I hope it will be helpful.

Thanks,

Sai Teja 

[lbendlin]

Please read through the release notes  On-premises data gateway October 2024 release | Microsoft Power BI Blog | Microsoft Power BI

[pthapa]

Hello@lbendlin ,Thank you for your response.
I went through the article but still wondering that my file was refreshing fine without issues before today but it started giving me the error after, why though? Why it worked before and not now?
I have hundreds of PBI reports and dashboards published in service and majority of them uses on permises data getway to connect to sql server instance. Does that mean possibly they will start failing as well for refresh sooner or later?

Thanks,

pthapa

[Anonymous]

Hi @pthapa ,

Is there only this one instance exception? Please check if the SQL certificate is valid, you can refer to the following steps:
Use SQL Server Configuration Manager to view and manage the certificates installed on your SQL Server instance. Navigate to SQL Server Network Configuration, right-click on Protocols for <instance name>, and select Properties. Under the Certificate tab, you can see the current certificate and its details.

Certificate management (SQL Server Configuration Manager) - SQL Server | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

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

[lbendlin]

You have been living on borrowed time. Your best option is to keep your certificates current.

[pthapa]

I am still lost, not understanding what to do next.
Do I need to update the gateway that was installed on the server?
I might need to tell my admin to do it but in order for them to understand what they need to do, I will need to tell them what they need to do if that is the case, becasue I am not the admin.
Can you please clarify little more.

Appreciate your time.

Thanks,