Forum Discussion
Power Automate button - export pages to pdf or pptx problem
Hello, I am posting here because I got no reply in Power Automate Community.
I wanted to add a button to my PBI report to extract pages from this dashboard to PDF and send it to me by email.
The problem is that the filters I apply on the published version are not taken into account. For example when i select values in Slicers about the Date, I want it to be displayed on my extracted pdf version of my dashboard. Nevertheless it isn't the case as I still see the default state of my dashboard (the state when it is published into the PBI Service): I don't see that I selected a date on my slicer .
Did I miss something in my flow ? I only have 3 steps: 1. click on the button, 2. Export to fil for PBI (PDF or PPTX) 3. Send email.
Thank you for your help !
ReportLevelFilter works just like URL filters which are explained here https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters
If you can dynamically construct a string like this example: "Store/Territory in ('NC', 'TN')" and pass it in the ReportLevelFilters it will filter your report accordingly.
8 Replies
Hello, I am posting here because I got no reply in Power Automate Community.
I wanted to add a button to my PBI report to extract pages from this dashboard to PDF and send it to me by email.
The problem is that the filters I apply on the published version are not taken into account. For example when i select values in Slicers about the Date, I want it to be displayed on my extracted pdf version of my dashboard. Nevertheless it isn't the case as I still see the default state of my dashboard (the state when it is published into the PBI Service): I don't see that I selected a date on my slicer .
Did I miss something in my flow ? I only have 3 steps: 1. click on the button, 2. Export to fil for PBI (PDF or PPTX) 3. Send email.
Thank you for your help !Hi Bastienlin_ ,
The "export to file" API will always export the report in it's saved state.
You can't just make changes to the report without saving it, and expect the API to export it with your changes.
If you want to apply filters you can add filter to the request. For filters and slicers you can use bookmarks
Hello AmosHersch,
So it is impossible to expect the "export to file" to be dynamic depending on the selections we do in the different slicers of the report ?
It is necessary that the print button take into account what we select in the slicers for the user...
Thank you for your answer !Bastienlin_ that's right, unless you have the Power BI report embedded in your own app, and then you can use Power BI Javascript API to capture bookmark of current state of the report, and provide that bookmark in the API request.
Hi Bastienlin_ ,
See this article for automated export of Power BI reports with filters and slicers applied to PDF / PPTX using BI Helper.
https://medium.com/bi-helper/burst-your-power-bi-reports-838ab593f7bc
This tool works with a single Power BI Pro license.
Hi Bastienlin_
Unless you have a specific reason to use Power Automate, you can automate the selection of dynamic filter and slicer values at report run-time entirely within Power BI. See https://medium.com/p/bfebd39d4c84 for details.
