cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atpbi10
Frequent Visitor

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?

3 REPLIES 3
v-yingjl
Community Support
Community Support

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

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
Community Support
Community Support

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.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors