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,021 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,910 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,201 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,133 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,570 points
868 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,570 points
1,068 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,360 points
638 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,360 points
977 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,570 points
27,771 views
+1 vote
1 answer

Have column with multiple values in powerBI, for use with a slicer in power bi

It can be achieved depending on the result you ...READ MORE

answered Oct 22, 2018 in Power BI by Hannah
• 18,570 points
6,931 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,910 points
891 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,910 points
9,478 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