I have a web API with basic authorisation and username and password How do i connect to it in Power BI

Question

I have a web API which has basic authorisation. The username and password is available with me. How do I get data from this API in Power BI?

Answer 1

Hey, @There,

I found your query is quite similar to the given link here https://www.edureka.co/community/26876/how-can-i-connect-my-web-api-with-power-bi-reports?show=26876#q26876

Have a look and let me know it worked or not!!

Comments

Hi Gitika,

Thanks for your response. I tried and it didn't work. It gave me

Web.Contents failed to get contents from 'my api url' (404): Not Found.

I have checked the API and it does work fine. What is it that I could be doing wrong? Also, where do I need to enter the basic auth credentials that I have for this API.

Also, I tried using the web connector in Power BI for connecting to this API, and it gives me the same error.

Regards.

---

Hey, @There,

To connect my web API with Power BI Reports, you can go through the following below:

Go to Home > Edit Queries > Advance Editor. Here is some Power Query code to query issue a GET request to an API endpoint.

let
    Source = Json.Document(Web.Contents("http://mywebapi"))
in
    Source