Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Can I ignore "SSL Certificate Issue" in M-Query just as we do -k in curl or verify=False in Python?

I'm facing the issue while trying to call an API from a public IP address in power query as follows:

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"]]))

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 (


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!



Community Support
Community Support

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. 

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors