Forum Discussion
Power BI Data Refresh
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
1 Reply
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-issued/td-p/354074
https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/
Regards,
Lydia
