Forum Discussion
Regarding the ExportFilter functionality
Hi PoovigaS,
Thank you for reaching out to Microsoft Fabric Community.
When exporting an embedded report using getFilters() will not give you the full state the user sees.
The supported way to export a report exactly as the user sees it is to capture the report’s current state as a bookmark and pass it to the Export API. Please follow below steps:- On the client, wait until the report is fully rendered and call
report.bookmarksManager.capture({ allPages: true, personalizeVisuals: true }) - Send the captured state(base64 string) to your server.
- In your ExportToFile API call, pass this value into defaultBookmark.state or per page bookmark.state.
This way the exported pdf matches what the user sees in the embedded report.
Thanks and regards,
Anjan Kumar Chippa
- On the client, wait until the report is fully rendered and call
Hi PoovigaS,
Thank you for reaching out to Microsoft Fabric Community.
When exporting an embedded report using getFilters() will not give you the full state the user sees.
The supported way to export a report exactly as the user sees it is to capture the report’s current state as a bookmark and pass it to the Export API. Please follow below steps:
- On the client, wait until the report is fully rendered and call
report.bookmarksManager.capture({ allPages: true, personalizeVisuals: true }) - Send the captured state(base64 string) to your server.
- In your ExportToFile API call, pass this value into defaultBookmark.state or per page bookmark.state.
This way the exported pdf matches what the user sees in the embedded report.
Thanks and regards,
Anjan Kumar Chippa
Hi v-achippa
Thank you for the solution. It worked. I just wanted to confirm that once after the filter is applied and exported, is there limitations from powerbi side to not export full data instead it shows only the first few rows thats in viewport. It only exports the data that is currently loaded in the visual, not the entire dataset?
Visuals are rendered in batches (TOPN(501,...) for example - whatever is required to render all currently visible pixels. If you want all the data, run a DAX query instead.
