Forum Discussion
Power Automate - Export to pdf button 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. (I want to do it because I can't use the extract button from PBI Service as I use the Embedded version of it)
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 what 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 !
17 Replies
- lbendlinSuper User
Needs more details. Show an expanded version of the second step.
- Bastienlin_Helper II
Hi lbendlin?,
In the Second step "Extract to file", I just selected the workspace, the report that i want and the pages that I want actually.
But someone just told me in the forum that the Export to file step will always export the report in it's saved state, without taking into account what we do in the slicers.
Do you know if there is a way for this step to take into account what the user select in the slicers ? It is necessary for a print button to get these filters...
Thank you for your answer !- lbendlinSuper User
if you look at the second step again you see many more options including report filters, pages, bookmarks and identities.
- mlozanoHelper III
Did you include the Date field (The same one you use in the slicer) when you created the Power Automate visual object or the specific case is that your button does not work in a report published with a public link?
- Bastienlin_Helper II
Hi mlozano,
Do you mean that if I put the date field (same from the slicer) in the button object, the "Export to file" step will take into account what we select on the slicer ? Someone in the forum just told me that the Export to file step will always export the report in it's saved state, without taking into account what we do in the slicers.
Thank you for your answer !