cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

SSL Certificate Issue - can I ignore it?

I am trying to connect to a server on my home network.  It is HTTPS and there is some problem with the certificate.  However I know it is safe and I want to connect to it with Power BI.

 

I get this error message.

Details: "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

 

I note there are some advanced settings where I can set some http request header parameters.  Is there some setting here that I can use to ingore the certificate issue and allow me to connect?



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
1 ACCEPTED SOLUTION
Community Champion
Community Champion

Hi Matt,

 

Try this:

 

Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:

  1. In Internet Explorer, click Tools, and then click Internet Options.
  2. Click the Content tab, and then click Clear SSL state.

Or 

 

You can ignore the certificate issue and it will let you connect to the PowerBI.com

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

11 REPLIES 11
Frequent Visitor

Even I'm facing this issue while trying to call an API in power query. I'm also looking for how to ignore the cert check, just as we do -k in curl or verify=False in python

Frequent Visitor

Can someone respond to the questions posed to turn off SSL cert validation so that the dashboard can get data from internal servers without having to setup SSL?

Frequent Visitor

Matt,

I've got a question - I've got some internal servers that are safe, but don't have any certificates (and I've been told getting those would take a MASSIVE effort) on those servers.  Is that what you mean by safe?

I've tried the solution here to no avail, I don't know if I should try again (for the 4th time?)

Any thoughts?

Sorry, I don't have any more knowledget other than what was shared in this thread.  But yes, when I say "I know it is safe" I mean it is my server and I trust it, with or without certificates.  A certificate only helps me trust servers I don't know.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Is this the only solution? I've tried it and it hasn't worked. I am using "Get Date - Web" to hit an API from an internal server. It is coming back with the "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel" error. I know the server is safe and trying to figure out how to use the API. Any other help with this?

Did you manage to get this to work?  I am having a similar issue trying to use "Get Date - Web" to use an API from an internal server and the same error "The underlying connection was closed:  Could not establish trust relationship for the SSL/TLS secure channel".  I would be interested to hear if you managed to get this working.

Community Champion
Community Champion

Hi Matt,

 

Try this:

 

Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:

  1. In Internet Explorer, click Tools, and then click Internet Options.
  2. Click the Content tab, and then click Clear SSL state.

Or 

 

You can ignore the certificate issue and it will let you connect to the PowerBI.com

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.

View solution in original post

How do you ignore it? It doesn't allow to ignore the SSL error.  I cleared the SSL State and didn't solve the issue

sorry but how do you ignore it?
I have two options : edit and retry, and the edit option has no ignore option 😞

Anonymous
Not applicable

Hi @BhaveshPatel ,

 

I am connecting Vmware vSphere Client from Power BI using web source and I get the same error.

 

I tried clear SSL state but still not working. Is there any way else I can try?

Thanks.  That fixed it.



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors