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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
Employee
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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors