cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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

 

One (but only one ) of our users is getting the error message above when trying to log connect to a server in power BI.  I'm a little confused about this because if there was a certificate problem I would expect more users to have the same problem.  Any help would be much appreciated. Thanks in advance

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

From error message I don't believe this is a Power BI desktop issue per se.  The respective machine doesn't trust issuer of the cert being presented to client.   YOu can try to connect from Excel on same machine to see if it works...but it shouldn't.

 

Is the user being affected a new user? On same domain as others?   Do you run your own CA?  Is person trying to connect to sql server?  If so, does the sql server have cert self signed/ signed by internal CA or trusted, public CA?  CA trusts pushed out via Group Policy? 

 

Lots of thing to check, so maybe best to get with your IT department.

View solution in original post

6 REPLIES 6
Highlighted
Solution Sage
Solution Sage

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

From error message I don't believe this is a Power BI desktop issue per se.  The respective machine doesn't trust issuer of the cert being presented to client.   YOu can try to connect from Excel on same machine to see if it works...but it shouldn't.

 

Is the user being affected a new user? On same domain as others?   Do you run your own CA?  Is person trying to connect to sql server?  If so, does the sql server have cert self signed/ signed by internal CA or trusted, public CA?  CA trusts pushed out via Group Policy? 

 

Lots of thing to check, so maybe best to get with your IT department.

View solution in original post

Highlighted
Regular Visitor

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

Thanks for your response.  We have been able to connect to the same server using  Excel, which was a bit of surprise to us as well.

 

The person effected is one of our heavier users of Power BI, so it's not a new user issue.  The message just started appearing a few days ago

 

Thanks for suggesting that in might be the PC. I hadn't thought of that. I will try having the user sign and try to connect to the same Server from another PC

Highlighted
Microsoft
Microsoft

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

@KWilliam,

In your scenario, please 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. For more details, please review the following similar blog.

https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

It appears that the problem was in the users PC.  We installed power BI on another laptop and had her get data from the same server, and there was no issue.

Highlighted
Frequent Visitor

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

Had same issue today with a user who git a new windows 10 laptop.

Changed her datasource setting from Microsoft Account to Windows Login and she could continue to refresh data.

Highlighted
Regular Visitor

Re: provider: SSL provider, error 0:The certificate chain was issued by an authority that is not tru

I have reinstalled the SQL Server certificate ( find it here ) and then cleared the "Global permissions" ( find it here ) on the power bi file dataset and the user was able to connect and refresh/access the dataset.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Solution Authors
Top Kudoed Authors