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.
I'm facing the issue while trying to call an API from a public IP address in power query as follows:
let
Source = Json.Document(Web.Contents("https://xxxxx/api/v2/nodes", [Headers=[Accept="application/json", Authorization="Bearer SIGNED_JWT", ContentType="application/x-www-form-urlencoded;charset=UTF-8"]]))
in
Source
The issue is
"The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."
However, when it' still work well if I try with Curl. I have tried some ways but it does not work even from this source:
Solved: SSL Certificate Issue - can I ignore it? - Page 2 - Power Platform Community (microsoft.com)
How to ignore the SSL/TLS Certificate check, just as we do -k in curl or verify=False in Python?
Any suggestions would be great helps!
Hi, @lionx
Please refer to the following links in the hopes of helping you.
Solved: SSL Certificate Issue - can I ignore it? - Microsoft Power BI Community
Solved: API web source credential has a SSL/TLS error - Microsoft Power BI Community
Web Source via Gateway - Could not establish trust... - Microsoft Power BI Community
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-zhangti
Thank you for your response. I have gone through and tried the solutions mentioned in the three links above but It does not work for me. Now I try to install an SSL Certificate and hope it works.
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 |
---|---|
112 | |
100 | |
76 | |
74 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |