Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi friends,
I am trying to import from World Bank resource (http://www.worldbank.org/) through API.
When I type in the following call in the browser - it works fine:
http://api.worldbank.org/V2/incomeLevel/LIC/country
But when I create a new Web Query in Power BI Desktop - it gives me an error:
"Unable to connect:
We encountered an error while trying to connect.
Details: "Access to the resource is forbidden."
I have cleaned the Global Data Source permissions, tried again, chose "Anonymous" authentication...
Still - the same error.
I am able to connect to the same url in the Dataflows - so the url and Anonymous authentication are working.
Something in my Desktop?
Please suggest
Thanks!
Solved! Go to Solution.
Ok.
I think my IT Department is blocking API calls from inside applications (but not from browser)
That's why it is not working.
Ok.
I think my IT Department is blocking API calls from inside applications (but not from browser)
That's why it is not working.
Hi @Anonymous ,
Have you solved your problem?
If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.
If you still need help, please feel free to ask.
Best Regards,
Cherry
Hi @Anonymous ,
But when I create a new Web Query in Power BI Desktop - it gives me an error:
"Unable to connect:
We encountered an error while trying to connect.
Details: "Access to the resource is forbidden."
Do you mean that you create a Web query in Advanced Editor?
Please have a reference of the query below.
let Source = Xml.Tables(Web.Contents("http://api.worldbank.org/V2/incomeLevel/LIC/country")) in Source
More information here: https://msdn.microsoft.com/en-us/library/mt260892.aspx
and here: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |