Forum Discussion
Advocate IGenerate a PDF per parameter value in Power BI Paginated Reports
I am creating a Power BI Paginated Report with various metrics for a single customer based on selecting it as a parameter. Is there a way to automatically generate a PDF per parameter value? We have over 1000 customers and it is not feasible to generate and save each one individually, even using the URL method.
Thank you for any guidance you have!
3 Replies
- mahoneypat
Microsoft Employee
Instead of making Customer a parameter, just set up a Group on it at the parent level and set it up to do a page break on it. That will result in a 1000-page pdf. If you want 1000 individual pdfs, you'll need to set up a Flow to iterate over a list/table of Customers and make a call to export the paginated report for each (not sure how performant that will be).
Regards,
Pat
AndyWaldThanks Pat!
For better or worse, we do need separate PDFs for each customer in order to share. I will work on creating a Flow. I was hoping there was a more straight forward solution that I was missing.
Can you print into one giant pdf and then use python to parse it into individual pdfs for each customer?
