Forum Discussion
Connection Error
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.
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
6 Replies
- VijayP
Community Champion
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
- PhilipTreacy
Super User
Hi Anonymous
Is your API URL using HTTPS? Try just using HTTP://
Regards
Phil
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
But still getting the same error.
- 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
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
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
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
