Forum Discussion

MattAllington's avatar
MattAllington
Community Champion
9 years ago
Solved

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?

Need Help
  • BhaveshPatel's avatar
    BhaveshPatel
    9 years ago

    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

     

14 Replies

  • ntaylor_carollo's avatar
    ntaylor_carollo
    Frequent Visitor
    6 years ago

    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?

  • BhaveshPatel's avatar
    BhaveshPatel
    Super User
    9 years ago

    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

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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

    • jverrey's avatar
      jverrey
      New Member
      6 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      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?

  • ccd_mgood's avatar
    ccd_mgood
    Frequent Visitor
    9 years ago

    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?

    • MattAllington's avatar
      MattAllington
      Community Champion
      9 years ago

      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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        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?
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi,

    sorry I have the same problem (more or less). I want to connect PowerBI to VMware vsphere to have the virtual machines and do stuff. I get the SSL issue when I use the web "get data" and put it the HTTPS vmware from this page 

    https://fpvcs-prd.tissue.kpl/rest/vcenter/vm

    I need help! 🙂