cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KWilliam Frequent Visitor
Frequent 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
mattbrice Senior Member
Senior Member

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
mattbrice Senior Member
Senior Member

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

KWilliam Frequent Visitor
Frequent 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

Moderator v-yuezhe-msft
Moderator

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.
KWilliam Frequent Visitor
Frequent 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.

PowerJoost Frequent Visitor
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.

marthafrancisco Frequent Visitor
Frequent 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
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors