powerbipowerbi-rest-api

Get Power BI Report Data from REST API with Service Principal


I have a service principal configured to access Power BI. I can successfully use the REST API to get metadata about dashboards, reports, and datasets. What I can't seem to be able to do is get the actual data displayed in the reports - i.e. the data as displayed in the visualizations as a table. This data can be seen as a table in the report visualization edit view of Power BI.

Is it possible through the REST API, using a service principal, to get this report visualization data in a tabular format?

If so, what endpoints return this data?


Solution

  • There isn't a REST API to get the data results of a visual in a report.

    What you can do is query the model directly via Datasets - Execute Queries In Group.

    Otherwise, you'll need to explore scraping the visual data via tools like Selenium, or via Embed/Client API - Export data from a visual