Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
92 | |
83 | |
71 | |
49 |
User | Count |
---|---|
143 | |
120 | |
110 | |
59 | |
57 |