Power BI Embedded report fail to export with slicer selection

[PrasadPBI0398]

The 'Embed to Customer' level of our application has a Power BI report embedded in it. Since there isn't a direct export option, we have made a different button using Export to file option to export the report. The report is currently exporting, but it is exporting with the default slicer selection. To fix this, we created a second filter selection box in the application, sent the report's parameters, applied the filter, and were able to export with the selected filter.

Nevertheless, we are unable to apply some of the distinct slicers that we have. These embedding scenarios are very cost-effective for embedding the report, but they are also very confusing and complex. and there are no suitable guidelines available to make this task simple to accomplish.

Is there any way to simplify these things by capturing the slicer selection automatically to get the Token export the report easily..?

currently we have P1 Sku capacity. embedded for Customer scenario through Service Pricncipal.

Thanks.

[HarishKM]

@PrasadPBI0398 Hey,
You can refer this document.

Use slicers when embedding a report in Power BI embedded analytics | Microsoft Learn

Thanks

Harish

Did I answer your question? Kindly give kudos and Mark my post as a solution!

[PrasadPBI0398]

Thank for the reply. 

We are checking...let you know if it is working

[Anonymous]

Hi @PrasadPBI0398 ,

Since you have p1 sku capacity, you can try to use the following api for report export.

Consider using bookmarks to capture the state of the report, including slicer selections. Bookmarks save the report's configuration and can be exported using the API.

Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PrasadPBI0398]

Hi Adamk Kong,

Thanks for the reply.

Does the Power BI report require any bookmark creation? or it must execute the entire operation from the application code. in that instance, if a user modifies any slicer on any report page. Will every page in the report be affected and exported in that particular state? 

[Anonymous]

Hi @PrasadPBI0398 ,

If you need to keep the state of multiple slicers, you can create multiple bookmarks. You can refer to below document: Create page and bookmark navigators - Power BI | Microsoft Learn

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.