Import from Web API error

[Anonymous]

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!

[Anonymous · Accepted 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.

[v-piga-msft]

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

[v-piga-msft]

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