Rest API as source does not work in service

[Anonymous]

I have a report with a Rest API source from a website, which refreshes fine in Power BI Desktop, but gives an error in the service. 

The result is json.

This is my code:

The error given in the service is "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server. "

I have set up my credentials on the server as Anonymous.

I have tried with both the skip test connection on and off, both don't work. 

What do I need to change?

[PhilipTreacy]

Hi @Anonymous 

If the API is returning HTML then it could be a 401, 403 or 404 error message. Or perhaps a firewall is blocking the request.

The username and password are definitely correct?

Has the Token expired?

You could try using Postman to issue the requests and see what is being returned.

Regards

Phil

---

If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.