topic Re: Export Reports with Actual Data Power Bi from API in Developer

Export Reports with Actual Data Power Bi from API

alexandrejdeos — Sun, 10 Mar 2024 19:28:01 GMT

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?

Re: Export Reports with Actual Data Power Bi from API

lbendlin — Sun, 10 Mar 2024 21:04:20 GMT

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

Re: Export Reports with Actual Data Power Bi from API

v-nokumar — Wed, 08 May 2024 07:42:01 GMT

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

Re: Export Reports with Actual Data Power Bi from API

lbendlin — Wed, 08 May 2024 11:05:04 GMT

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

Re: Export Reports with Actual Data Power Bi from API

AmosHersch — Wed, 08 May 2024 11:08:21 GMT

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.

Re: Export Reports with Actual Data Power Bi from API

v-nokumar — Wed, 08 May 2024 14:11:17 GMT

Hi @AmosHersch ,

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

Thanks

Re: Export Reports with Actual Data Power Bi from API

AmosHersch — Wed, 08 May 2024 14:30:03 GMT

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