PowerBI, Power Query disable SSL certificate verification

[Roka]

There exists no resource online demonstrating how to turn off SSL certificate verification. Postman, C#, and virtually everything else has an option to turn this off. I am wondering if PowerBI has the same. If not, what alternatives are there to permanently turn off SSL certification in PowerBI?

[raduuntaru]

Hi, I have allmost the same problem i need PBI to compare some columns with date, but if the result is false I need PBI to return a text statement. In exchange I received the same error with Expressions that yield variant data-type cannot be used to define calculated columns. Ps I also used tbe format and value formulas but no result.
Thanks

[v-yuta-msft]

Hi Roka,

Please refer to links below:

https://community.powerbi.com/t5/Integrations-with-Files-and/SSL-Certificate-Issue-can-I-ignore-it/t...

https://stackoverflow.com/questions/12506575/how-to-ignore-the-certificate-check-when-ssl

https://stackoverflow.com/questions/33084855/way-to-ignore-ssl-certificate-using-httpsurlconnection

Regards,

Jimmy Tao

[Roka]

Jimmy,

The actions recommended in the first link don't resolve me issue.  I still get "DataSource.Error: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel." when using power query.  The last two don't help me.  I am using power query.  Are there any other options?