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
9,604 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/

If you wish to master Power BI Concepts, check out Power BI Training Topics now!.

answered Oct 18, 2018 by Annie97
• 2,160 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,770 points
3,576 views
0 votes
0 answers
0 votes
1 answer

How can I leverage the Power BI REST API for automated report deployment and management within my organization?

To ensure easier deployment and maintenance of ...READ MORE

answered Nov 14 in Power BI by pooja
• 4,690 points
18 views
0 votes
0 answers

How can I track and log user interactions with Power BI reports?

How can I track and log user ...READ MORE

2 hours ago in Power BI by Evanjalin
• 5,530 points
6 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,130 points
1,309 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 22, 2018 in Power BI by nirvana
• 3,130 points
2,722 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,520 points
1,491 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,350 points
1,646 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,160 points
6,729 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