Forum Discussion
Import from Web API error
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!
3 Replies
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 SourceMore 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
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
