how can I connect my web api with Power BI Reports

Question

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.

Answer 1

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

Also Read:

PowerBI API Rest API for updating the Datasource ID?

If you wish to master Power BI Concepts, check out Power BI course online now!.