Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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 v...
Need Help
NavathaD's avatar
NavathaD
Frequent Visitor
5 months ago

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.

  • garamond's avatar
    garamond
    New Member
    5 months ago

    Hi NavathaD ,

    It is not simple to loop through the slicers and create report exports. I would try 1) Claude Code or Codex, 2) 3rd-party reportin app like Slideform. I use Slideform and they have a solution that works beautifully with Power BI to bulk export reports in whatever format you want.

    • NavathaD's avatar
      NavathaD
      Frequent Visitor
      5 months ago

      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

      • garamond's avatar
        garamond
        New Member
        5 months ago

        Hey NavathaD ,

        Yes these are AI tools. You might be able to use these tools to write a better Power Automate script. It's worth a try; these tools are pretty good at figuring out stuff like this. Just ask it to write your script for you.