Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
verdan
Frequent Visitor

PowerBI REST API - Extract the underlying data model of report pages/visualizations

To extract the underlying data model of a report, and which PowerBI Tables and Columns are being used within a report, we’ve been utilizing the REST API to export reports in .pbix format.
https://learn.microsoft.com/en-us/rest/api/power-bi/reports/export-report-in-group


Unfortunately, in some cases, I’ve encountered difficulties when attempting to extract the underlying data model of larger reports, particularly when dealing with large dataset storage formats (https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-large-models) we get the error ServerError_PremiumFilesErrors_OperationIsNotSupportedForPremiumFilesModel.

Given these challenges, I am eager to understand how I can effectively work with massive reports or the ones that utilize large data formats.

Are there specific strategies or best practices that I should consider to mitigate the limitations posed by exporting such reports? 

Alternatively, I am keen to explore other methods for accessing the underlying data model of report pages/visualizations without solely relying on exporting reports. Is there a preferred approach or alternative solution that would enable me to retrieve this crucial information effectively?
4 REPLIES 4
lbendlin
Super User
Super User

Read about PBIP, TMDL, Git integration and general CI/CD guidelines.

@lbendlin thanks for your message, as I understood, downloading or exporting a report (via API) using PBIP is not yet supported. 

https://community.fabric.microsoft.com/t5/Developer/Export-API/m-p/3549748

It's the other way round. Start with the PBIP before you publish.

There are a couple of issues here:
- I have hundreds of reports, and it is not viable to re-publish all reports to pbip. 
- Even if I publish this as PBIP, I cannot download the report as .pbip via the API. 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.