Forum Discussion
Dynamically export pages to PDF based on slicer values
I am looking for a way to dynamically loop through values of a slicer and extract all pages of the dashboard for that value and then move on to the next value until it reaches the end of the slicer values. The closest I have been able to find so far is Play Axis dynamic slicer however I do not see a feature to run this on command via Power Automate flows.
The scenario is like this:
* I have 4 pages in my dashboard, the first page being hidden and containing only slicers and an execute button
* The execute button would be triggered from Power Automate flow to start the loop process
* The loop process will apply the filter values in sequential order and extract the 3 visible dashboard pages to PDF and save to the directory that is specified and send the dashboard to the contact that corresponds with that slicer value.
* When the end of the slicer values has been reached, the Power Automate flow will end
* The execute button could also be invoked manually if Power Automate is not preferred
I have read previously online that either R script or M formulae can be used to loop through filter values and extract to PDF, however I have not been able to find this documentation for a couple of years.
If anyone has done this type of reporting, your input is much appreciated.
Thanks,
Aaron
20 Replies
Did you find the solution Anonymous ?
I was also looking for something similar, I have a slicer on Page 1, which I use for page navigation. Only those pages get filtered/populated in the slicer for which some data exists, and then selecting the page in the slicer and using a button helps me to navigate to that page.
Now, I want to generate a PDF of only those pages that get populated in the Page Navigation slicer.
BipinLala26 I have not found a solution for this and ended up going a different route from Power Automate altogether. My alternate solution is not optimal, but I had to make a quick decision so I created multiple dashboards to suffice for now until a more permanent solution is found.
Apologies that I do not have a better answer at this time. If I find the solution that we are looking for, I will gladly post it back here.
Hi Anonymous
I find some offical blogs about export report by Power Automate flow. I hope they could help you.
For reference:
Export and email a Power BI report with Power Automate
Trigger a cloud flow from any Power BI report
Trigger flows from Power BI reports
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickl
Anonymous Thanks for posing your solution, and apologies for the very late reply. I have tried all of these things, but I still have not got this working yet. When I try to generate a Power BI report using a filter in Power Automate, it either gives an error that the criteria is not recognized or the report simply never arrives in my email. I have a temporary solution in place now until a more permanent solution is found.
Hi Amper! Would you please share your temporary solution?
I'm looking for something very similar to your case. Every month I pull around 100 pdf from specific slicers so it will be tremendously helpful if I can get a fully or semi automate solution.
Hello @Anonymous,
I'm in a similar scenario, where I looking to export my report pages to PDF based on the dynamic slection of the filter, populate the visuals accordingly and then loop through values in the slicer list and perform the same action untill end of the slicer list.
Any luck in finding an option other than the alternate approach that you took?Thanks,
RohithI have a solution to this issue if people are looking for one. You can find it in the belwo post -https://community.fabric.microsoft.com/t5/Desktop/Dynamically-export-the-report-pages-to-PDF-based-on-slicer-value/m-p/3508227/thread-id/1159568#M1162164
Hey there, This thread raises an importaqnt need that is apparently really hard to solve with Power Automate and the other MS tools. To address this need, Slideform has implemented a new feature to automate report exports from Power BI based on slicer values! Slideform is a 3rd party, no-code tool that automates the painful manual work of creating reports from your dashboard. All you have to do is connect Power BI, upload a report template (can be in PPT, PDF, Google Slides, Word, etc), and link the charts, metrics, & data to the report fields. Slideform automatically fills in all the content and can create batches of reports by cycling through slicers, client names, etc. Let me know if you have any questions.
Hello All, I have been working on this, to export dynamically chosen slicer values to be able to export to PDF's without any manual intervention from Power BI Dashboard ( has 20 pages , including Main Global Filters Page ) .The goal os to be able to generate PDF's as it is, just like some user clocks on couple of slicers on Power BI service, what he sees, should be in the PDF generated. I could not implement yet, with combination of slicers through Power Automate nor PowerShell, Bookmarks or by combining multiple report level filters into Single filter too. Please let me know, if anybody has idea on this and able to implement it. The idea is to implement for 250+ Report exports Quaterly. So far, one slicer works fine and able to generate 35 exports through PowerShell. It would be great to share your thought & suggestions on this.
Please find my flows screenshots and PowerShell error screenshots and expected combination of slicers and respective Reportnames/PDFs.
Thank you.
Hi There, Thank you for letting me know, looks like those are AI tools, please correct me if wrong . So, is there a limitation to use multiple filters in Power Automate http( post) Export to task and Powershell too ? I tried through Bookmarks, ReportLevelFilters , URL filers as well ,please let me know any idea.
Thank you
