Power BI Data Refresh

[pxg08680]

Hi Everyone,

      I have been facing an issue from past one day. I am unable to connect to SQL server from Power BI Desktop. Neither I am able to refresh existing reports. I have access to SQL server and able to work in SSMS without any problem. Attached is the error message that I see eveytime. I have checked with the credentials for Power BI Desktop account, database connection also.

Any help is very much appreciated.

Thank You

[Anonymous]

@pxg08680,

Make sure that the certificate used by the SQL Server is within the Trusted Root Certification Authorities store of the machine running the Power BI Desktop.

There are a similar thread and a blog for your reference.
http://community.powerbi.com/t5/Desktop/provider-SSL-provider-error-0-The-certificate-chain-was-issu...


Regards,
Lydia