Export Paginated Report PDF Looping Parameter Values
I have a paginated report that has multiple pages (let's say N), in which I have multiple charts and visuals. On the other hand, I have different customers (let's say 10), with different associated Customer_ID (from 1 to 10). Plus, Customer_ID has been set as a parameter in my paginated report.
My goal is to create one different PDF or PPT for each Customer_ID value. Thus, I would like to generate 10 different documents with N pages each. My questions are the following:
1) Is there a way to achieve this through the Power BI service? I mean, selecting a certain parameter range, and the Service will automatically create all 10 documents with N pages each.
2) I have seen this post which describes how to accomplish something similar, but it requires the use of Power Automate.
For the solution below, do you need an auxiliary file that contains the list of values that you want to iterate through? Or could you just read each value of a field from your Power BI report?