Showing results for 
Search instead for 
Did you mean: 
New Member

Export Paginated Report PDF Looping Parameter Values

Hi there,


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?

3) For the two questions above, could this be done for a regular Power BI report?


Thank you very much in advance



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors