Power BI
NewExtend API to include endpoint for retrieving used schema objects of report (visual)
Christian Skala on 18 May 2022 20:30:07
In a published Power BI report on eg. "Page1" the following schema objects are used in a visual: database, schema, customer table, and 4 columns (ie. city, creditlimit, zip code and state) which I would like to request through a REST API call. (unfortunately, I'm unable to attach a screenshot of the Power BI report for better explanation).
Key benefit of this feature is to determine what schema objects are the most used in reports/visuals across a project and help data analysts to make a better decision on which of these assets are essential and most critical to keep the depending reports up-to-date.
Therefor it would really make sense to access this information through a REST API call, eg.
GET https://api.powerbi.com/v1.0/myorg/reports/879445d6-3a9e-4a74-b5ae-7c0ddabf0f11/pages/Page1/metadata
which would return something like the following (as JSON object):
reportId UUID of report
pageId UUID of page
pageName Page1
database intl_customer
schema US
table customer
column city
column state
column creditlimit
column zip code