Connection Error

[Anonymous]

Dear Altruists, 

I am trying to get JSON data via rest api url. The rest api url I have is not SSL secured. 

When I am trying to provide user credentials it is showing the error that "Underlying connection is closed"

Is there any way to bypass this SSL certificate and establish the connection. 

If i can not by pass what else I can do to get the data from that REST API url. 

[PhilipTreacy]

Hi @Anonymous 

Do you have access to the API system to install an SSL certificate?  Most people don't and your initial query didn't indicate that you did.

The problem is that the API doesn't support SSL/HTTPS.  If you can install an SSL cert on the system hosting the API then that will fix the issue.

Regards

Phil

[Anonymous]

No I don't have the access to the API to install SSL. Our netowrker team currently can't provide the SSL certificate on that. I have have the credentials to access the API and the JSON files. 

SO they suggested me the links 

https://powerbi.microsoft.com/pl-pl/blog/ssl-security-error-with-data-source/

I downloaded the self signed certificate by following the link

https://www.panagenda.com/kbase/display/DM/How+to+export+your+self-signed+appliance+SSL+certificate+...

But still getting the same error. 

Is it possible to do it from my side. Enforce self signed certificate in Local machine. 

If not then what shall i response to the networker team cause I am naive to the networ server security issues.

[PhilipTreacy · Accepted solution]

Hi @Anonymous 

The problem is caused by thhe system the API is on not having an SSL certificate and therefore not supporting an HTTPS connection.

There's nothing you can do from your end on your PC to fix this, the changes must be made on the system/computer hosting the API.

Regards

Phil

[PhilipTreacy]

Hi @Anonymous 

Is your API URL using HTTPS?  Try just using HTTP://

Regards

Phil

[Anonymous]

I have found the following one as well. 

https://powerbi.microsoft.com/pl-pl/blog/ssl-security-error-with-data-source/

I downloaded the self signed certificate by following the link

https://www.panagenda.com/kbase/display/DM/How+to+export+your+self-signed+appliance+SSL+certificate+...

But still getting the same error. 

[VijayP]

@Anonymous 

Try this thread and let me know if this is helpful

https://community.powerbi.com/t5/Power-Query/Pull-data-from-a-REST-API-Authentication/td-p/246006