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 in Power BI by anonymous
• 120 points
122 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 by Gitika
• 48,320 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,200 points
5,438 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
2,075 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,410 points
125 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,410 points
79 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
• 51,970 points
155 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
• 51,970 points
171 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,410 points
7,671 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,410 points
4,368 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 in Power BI by anonymous
• 48,320 points
31 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 in Power BI by Gitika
• 48,320 points
36 views