Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
ccd_mgood
Frequent Visitor

Can I ignore ssl, ie connect via http (vs. https) or ignore missing certificates?

I have some (internal) servers I need to connect via the APIs, but as they've no certificates, Power BI is throwing a fit.

I am getting the "The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel."

Is there a way I can tell it to connect to these servers anyways?

 

I've tried the following solution to no avail: http://community.powerbi.com/t5/Integrations-with-Files-and/SSL-Certificate-Issue-can-I-ignore-it/m-...

 

My other option is to connect via the DBs directly, but as those are extremely hairy, the APIs would be much preferable.

4 REPLIES 4
v-sihou-msft
Microsoft Employee
Microsoft Employee

@ccd_mgood

 

You may try bypass the SSL issue in your code. Please refer to threads below:

 

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

 

I can't figure out why "Clear SSL State" doesn't work in your scenario. You can create a support ticket for deep analysis.

 

Regards,

 

Hmmmm, maybe I phrased my question wrong, but thanks for the reply!  I'm not actually using any code (besides PowerQuery and DAX)

 

When I said connecting to the APIs, I meant that within Power BI I'm using "Get Data", then using the Web data connector to tap into those web REST APIs for our internally hosted servers (CommVault, VMWare, Isilon, XtremIO, etc.)

 

Is there a way I can tell Power BI to trust specific internal servers, or disable the cert checks?  Probably a terrible idea, but trying to get this POC up and running at least.  If there's a safer solution, that's great as well - but I'm still learning about certs, and from what I've been told, getting those onto our internal servers is going to be a big problem.

I am encountering same problem.

Hi, did you solve the problem? Becasue I encountered the same problem,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.