Forum Discussion

atpbi10's avatar
atpbi10
Icon for Helper I rankHelper I
5 years ago

Self signed cerificate API powerbi power query

Hey I'm trying to retrieve the data from API which is hosted on azure VM with self signed certificate, using this code:

 

let
url = "https://***WEBSITEURL***/api/",
source_url = "***WEBSITEURL***/api/v2",
body = "{
""username"": ""***"",
""password"": ""****""
}",
Response = Json.Document(Web.Contents(url, [Headers = [#"Content-Type"="application/json"], Content = Text.ToBinary(body)])),
Source = Json.Document(Web.Contents(source_url, [Headers = [Authorization="Bearer "&Response[access]]])),
results = Source[results],

 

However Im getting the following error:

DataSource.Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.
Details:
https://***WEBSITEURL***/api/

 

What should I change in PowerBI to allow accessing such APIs that does have self signed certificates?

Need Help

4 Replies

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi atpbi10 ,

    Sorry for replying late. You can 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.

     

    You can also refer these articles:

    1. Could not establish trust relationship for the SSL/TLS Secure Channel – Invoke-WebRequest 
    2. Power Query Sign in, Certificates and Troubleshooting 

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • atpbi10's avatar
      atpbi10
      Icon for Helper I rankHelper I
      5 years ago

      This did not work. Do you think maybe that changing https configuration on Azure VM on which the api is deployed on might help?

      • v-yingjl's avatar
        v-yingjl
        Icon for Community Support rankCommunity Support
        5 years ago

        Hi atpbi10 ,

        Perhaps you could take a try and check it.

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.