topic Re: Power BI Embedded API - How to export a filtered report? in Developer

Power BI Embedded API - How to export a filtered report?

erosal84 — Thu, 10 Sep 2020 12:17:29 GMT

My application displays a Power BI report from my workspace via the Power BI Embedded API. My user has clicked an element of a bar chart visualization, which automatically filters the data on the other visualizations accordingly. Now, she wants to export that filtered view to a PDF. I've seen the code examples for doing an export to file, but that seems to imply just exporting the base report from the workspace. How do I export the current view of the report, as filtered by the user?

Re: Power BI Embedded API - How to export a filtered report?

Greg_Deckler — Fri, 11 Sep 2020 01:11:19 GMT

@dm-p Is this something you do?

Re: Power BI Embedded API - How to export a filtered report?

dm-p — Fri, 11 Sep 2020 02:51:08 GMT

Hey @Greg_Deckler - no, I have no experience with embedded, unfortunately. Sorry 😞

Re: Power BI Embedded API - How to export a filtered report?

Greg_Deckler — Fri, 11 Sep 2020 02:52:28 GMT

@dm-p No worries, thought I would ask!

Re: Power BI Embedded API - How to export a filtered report?

Anonymous — Wed, 16 Sep 2020 08:07:31 GMT

Hi @erosal84,

Perhaps you can take a look at power bi javascript api that use javascript to extract data from the current report and visauls:

PowerBI-JavaScript/wiki/Export-Data

Regards,

Xiaoxin Sheng

Re: Power BI Embedded API - How to export a filtered report?

lnoguera — Sun, 11 Apr 2021 16:46:18 GMT

I´m having the same issue when exporting a power bi embedded report to pdf. Even though I capture the current state of the report as a bookmark using the javascript sdk and then pass the bookmark state to the backend when exporting the report it only get exported in its initial state, meaning that when users interact with the report and the report data changes, those changes are not reflected in the exported file. Did you find a solution?