Loop through filter and export a PDF for every value

[avatar456]

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! 

[KiranHosakote]

@avatar456 

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. 

[lbendlin]

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.

[avatar456]

What other tools would you suggest? Free use is certainly not a requirement, I am looking for the best solution price/quality. 

[lbendlin]

Can't in good conscience recommend any of them.  Here's an example of an altenative approach. How to Auto-Schedule Data Export From Power BI - sqlitybi