Forum Discussion
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 d...
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.
What other tools would you suggest? Free use is certainly not a requirement, I am looking for the best solution price/quality.
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