how can I connect my web api with Power BI Reports

0 votes

Hi.

I have a web API to deliver the required data sources for my reports. I don't really know how can I connect my web API with Power BI. Can anyone help me out?

Thanks.

Oct 18, 2018 in Power BI by Upasana
• 8,620 points
5,850 views

1 answer to this question.

0 votes

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

More information here: https://msdn.microsoft.com/en-us/library/mt260892.aspx

and here: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/

answered Oct 18, 2018 by Annie97
• 2,200 points

Related Questions In Power BI

0 votes
1 answer

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

Hey, @There, I found your query is quite ...READ MORE

answered Oct 29, 2020 in Power BI by Gitika
• 65,850 points
246 views
0 votes
1 answer

How can i see my plugin name in the Power BI Visual plugin List ?

there is a couple of errors in your ...READ MORE

answered Nov 8, 2018 in Power BI by Upasana
• 8,620 points
195 views
0 votes
1 answer

How can I use Power BI on my Ubuntu machine

Hey, @Jublleevdsl, Based on my research, currently, it ...READ MORE

answered Nov 23, 2020 in Power BI by Gitika
• 65,850 points
165 views
0 votes
1 answer

How many reports can be created in one Power BI reports

You have a limit of 1000 datasets ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,550 points
139 views
0 votes
1 answer

Displaying Table Schema using Power BI with Azure IoT Hub

Answering your first question, Event Hubs are ...READ MORE

answered Aug 1, 2018 in IoT (Internet of Things) by nirvana
• 3,150 points
287 views
+1 vote
1 answer

Unable to install connector for Power Bi and PostgreSQL

I think the problem is not at ...READ MORE

answered Aug 21, 2018 in Power BI by nirvana
• 3,150 points
1,351 views
+2 votes
2 answers

Migrate power bi collection to power bi embedded

I agree with Kalgi, this method is ...READ MORE

answered Oct 11, 2018 in Power BI by Hannah
• 18,550 points
375 views
+1 vote
1 answer

Connect power bi desktop to dataset and create custom reports

Yes using Power BI REST API to ...READ MORE

answered Sep 18, 2018 in Power BI by Kalgi
• 52,290 points
407 views
0 votes
1 answer

How to export Power Queries from One Workbook to Another with VBA?

Try solving it using the Workbook. Query ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,200 points
1,534 views