Load data in Power BI Service from a local REST API

[Nerst]

I am running a local REST API from a Flask Python script.

One of the endpoints is called /all_data that loads a list of json events.

The API is running on, let's say, http://127.0.0.1:8000 on the browser.

I would like to know, whether is it possible or not, in PowerBI Service (in Desktop as well), to import the data fetched by the endpoint http://127.0.0.1:8000/all_data/ to build a reporting Dashboard?

[v-stephen-msft · Accepted solution]

Hi @Nerst ,

You could call Power BI REST API from custom connector. Please kindly refer to

How to Call Power BI REST APIs with Custom Connector and Postman

Or try the solution in the following post:

Solved: Using a REST API as a data source - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.