Forum

Getting Error while...
 
Notifications
Clear all

Getting Error while trying to access the data from web

2 Posts
2 Users
0 Reactions
135 Views
(@krishna-chaithanya)
Posts: 1
New Member
Topic starter
 

When I’m trying to access the data from web, it is throwing an error that the request was aborted. could not create ssltls secure channel.

I am using Excel 2016.Is there any specific modification or any update which I need to do.

could anyone guide me on this.error.PNG

 
Posted : 09/02/2021 12:55 am
Philip Treacy
(@philipt)
Posts: 1632
Member Admin
 

Hi Krishna,

You're running this from my query to NASA from this blog post?

https://www.myonlinetraininghub.com/getting-started-with-apis-in-power-query  

I don't know why you'd get that error.  The Excel file still works for me

Can you try this link which is the same link, you should get a page of data returned in your browser

https://api.nasa.gov/insight_weather/?api_key=DEMO_KEY&feedtype=json&ver=1.0

Perhaps you have security/anti-virus software on your PC or network that is preventing the connection from being made.  What securtiy/AV are you using?  Are you trying this connection from a work PC or over a VPN?

Regards

Phil

 
Posted : 10/02/2021 7:38 am
Share: