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.
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