Certificates Issue

[sohaibaman5]

While creating a coonection to the sql server through PowerBI Service gives this error:
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.)

Unable to create data source. Unable to connect to the data source.

Details: VM_Gateway: 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.) Please have this information handy if you choose to create a support ticket. ActivityId: 1b9a138d-4918-4d7d-b412-47ebe1cc9381 RequestId: 777a8070-cd9b-4319-9ed9-abc1011261bb Cluster URI: https://api.powerbi.com Status code: 400 Time: Wed May 18 2022 16:18:02 GMT+0500 (Pakistan Standard Time)

How to correct this certificates issue?

[v-xiaoyan-msft]

Hi @sohaibaman5 ,

Please refer to this official document for the cause of the problem and the solution.

The certificate received from the remote server was issued by an untrusted certificate authority err... 

Best Regards,
Community Support Team _ Caitlyn