Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Loop through filter and export a PDF for every value

Hi, 

 

I'm looking for a solution to share my report. I would like to loop over the slicer in my report en generate a PDF for every possible value in the slicer. 

 

What is the best solution to do this? I'm finding a lot of information about this but nothing seems to work. 

Which license do I need? 

Is it possible with Power Automate? 

 

Thanks for helping me out! 

Need Help

4 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    You can use Power Automate to run a DAX query to retrieve the slicer values (make sure you recreate the filter context) and then request the individual PDF extracts. Note that Power Automate is not designed for mass processing, you will be throttled after eight exports.

     

    There are lots of other tools that claim to do the same thing, and better. None of them are free as far as I know.

  • KiranHosakote's avatar
    KiranHosakote
    Post Patron
    3 years ago

    Anonymous 

    See if BI Helper https://bihelper.tech meets your use case to generate user-specific PDFs (with filters and slicers applied). It works with Power BI Pro and does not need Power Automate.