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

0 votes
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?
Oct 29, 2020 in Power BI by anonymous
• 120 points
3,515 views

1 answer to this question.

0 votes

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!!

answered Oct 29, 2020 by Gitika
• 65,890 points
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

Related Questions In Power BI

0 votes
1 answer

how can I connect my web api with Power BI Reports?

Go to Home > Edit Queries > ...READ MORE

answered Oct 18, 2018 in Power BI by Annie97
• 2,160 points
9,575 views
0 votes
3 answers

How do I get token using javascript API while trying to embed graphs using Power BI

Use ADAL.js that will give you an ...READ MORE

answered Jun 22, 2019 in Power BI by anonymous
4,525 views
0 votes
1 answer

How do I know who in my organization has a Power BI account?

You can view the Azure Active Directory ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,540 points
1,112 views
0 votes
1 answer

How Do I Find Power BI users that have signed in

If you are a tenant admin, and ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,540 points
1,461 views
0 votes
1 answer

How do I download or have my Power BI Data Analyst certificate sent to my email?

To download your Power BI Data Analyst ...READ MORE

answered Oct 24 in Power BI by pooja
• 1,220 points
41 views
0 votes
1 answer

What are the components I need to excel to become a pro in power BI

Having knowledge about these topics is a must.  Power ...READ MORE

answered Oct 8, 2018 in Power BI by Kalgi
• 52,350 points
837 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
1,209 views
+2 votes
2 answers

How do I undo something in Power BI?

To undo your last action or last few actions, press ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,540 points
29,953 views
0 votes
1 answer

How to Toggle Between Two Option and Make it Interact with the rest of the Visualizations in a Report?

Toggling is an action that is achieved ...READ MORE

answered Oct 20, 2020 in Power BI by anonymous
• 65,890 points
1,085 views
0 votes
1 answer

How do you Hide and Unhide a Specific Report in Power BI?

In the menu bar, choose the Selection ...READ MORE

answered Oct 20, 2020 in Power BI by Gitika
• 65,890 points
10,531 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP