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!.

Additionally, users working with Power BI's time intelligence functions may encounter scenarios where DAX measures display incorrect values, which often stems from improper date table configuration or filter context issues in the model.

Understanding DAX functions is essential for creating effective Power BI reports, but sometimes, users may encounter a situation where visuals appear blank after applying specific filters. This issue can arise due to incorrect filter context, missing data, or improperly defined DAX measures.