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?
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