REST query fails due to SSL / TLS issue RRS feed

  • Question

  • Hi,

    we're using an internal, enterprise PKI to create certificate for our internal web sites. Opening the web page in IE all looks fine, the whole certificate chain is green.

    Unfortunately if I try to query the webservice with Power Query in Excel I got the following error:

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

    Thanks in advance


    Monday, September 4, 2017 1:24 AM


  • Hey!

    I'd recommend that you try checking your network traffic with Fiddler to see what's going on with the request to see if it's actually being sent correctly or not and if what error you might be getting from the web service. You could post the Fiddler trace so we can take a look, but Power Query does accept SSL connections with web services. 

    Perhaps your web service requires some sort of Header to gain access as some sort of auth? even then, you shouldn't be getting that SSL/TLS issue unless something is wrong.

    Monday, September 4, 2017 11:43 AM