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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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?
3 REPLIES 3
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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.