Power BI desktop to SQL connection failures

[Anonymous]

Hi. I did raise this would our IT teams. i have this error below and gateways applied etc. Its been working fine for a month now if I refresh my employee dimension from SQL, the table goes blank and returns error below

Please advise?

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.)"

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You may not have a CA signed certificate installed in your SQL VM's trusted root store.

You could refer to this thread:https://community.powerbi.com/t5/Desktop/provider-SSL-provider-error-0-The-certificate-chain-was-issued/td-p/354074 

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