IMPORTANT || Certificate issue with Microsoft SQL Server

[PremK]

Hi all 

SQL Server uses Pioneer Rx data.
I had connected this SQL Server with SSMS and its connected well and able to interact with the data bases and tables in it.
But while i tried to connect the same SQL Server with Power BI to create reports its showing error like 

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

kindly anyone provide me solution to Connect SQL Server and PBI...

[PremK]

I read this documention and done some changes accordingly, but it doesn't help me out.

I'm getting the same error again. 

[lbendlin]

Have you considered talking to the owner of the SQL server to renew the certificate?

[lbendlin]

Certificate revocation check, Power BI Desktop - Power BI | Microsoft Learn