Regarding the ExportFilter functionality

[PoovigaS]

I’m working with Power BI Embedded and trying to export a report (to PDF) while respecting the filters that a user applies in the embedded report. Is there any supported way to capture the user-applied filter state from the frontend and pass it into the export API? I tried using getFilters() on report, pages and visuals, but it isn't giving me the exact filter that users applied.

[v-achippa · Accepted solution]

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

[PoovigaS]

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?

[lbendlin]

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.