Export Reports with Actual Data Power Bi from API

[alexandrejdeos]

We have implemented the export of the Power BI file using the ExportReports API (https://learn.microsoft.com/pt-br/rest/api/power-bi/reports/export-report). However, the return does not consider the data segmentation selected by the user with the current values, exporting the file in PDF/PPTX disregarding the filtered data in the segmentation with the default data. We did not identify in the documentation the procedure that should be implemented. How can we implement the export considering the current data selected by the user?

[v-nokumar]

Hi @AmosHersch ,

Could you please give me an example to bookmark using javascript API? So, I will get better image for this?

Thanks

[AmosHersch]

I think you can start from these articles explaining bookmarks with sample code:
Enhance your users' experience with bookmarks in Power BI embedded analytics | Microsoft Learn

Capture report views showcase | Microsoft Learn

You can use Power BI Embedded Playground for testing the APIs
What is the Power BI embedded analytics playground - Power BI | Microsoft Learn

[v-nokumar]

Hi @lbendlin ,

To pass value in Report Level Filters, we need to know what value is selected and how can we achieve that selected values at run time.

Thanks

[AmosHersch]

You can use bookmarks for that purpose.

If you have an app embedding the report then you can capture the report state as a bookmark using Javascript API, and pass the captured bookmark state to the API.

[lbendlin]

Then use Power BI for the export. With Power Automate there is no filter context.

[lbendlin · Accepted solution]

When you export via the API there is no "user" and no "user selections" .  You can specify report level filters or bookmarks.