Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi Power BI Team,
I am exporting power BI report to pptx using power BI API. But, now I have to export with applied filters and to do this I need to know what is filtered and so I can pass the filter parmeters to export.
I can see, in microsoft itself given one parameter to send reportlevel filter like below in link-
https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to
But to pass value in it, from where I can get need to know.
So, Could you please help me if there any API or any other solution?
What is your end user scenario? Can they not do the export themselves?
Hi @lbendlin ,
Here are the full scenario for end users -
From Power BI desktop or Web, users have restrictions to do filters/edit/insertion/delete, So they can export power bi but they can't filter as well.
So, we have provided them to load report in our site where we have integrated with Power BI and they can filter also, and after that they can export with applied filters.
Here I have given flow as below-
So, that's why I need to know how can I export to ppt with filters applied instead of all data.
Thanks
The only solution I can think of would be to capture the report's state as a bookmark using the Javascript library and then send this bookmark state to the export to file API
Hi @AmosHersch ,
Yes, by using JavaScript API, Now I am able to export with applied filters.
Thanks you so much
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |