Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Hey buddy did you found a solution to that error?
Hi @atpbi10 ,
Sorry for replying late. You can try this:
Clear the Secure Sockets Layer (SSL) state. To do this, follow these steps:
You can also refer these articles:
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.
This did not work. Do you think maybe that changing https configuration on Azure VM on which the api is deployed on might help?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |