Good question. This is a very common point of confusion when building automated reporting with Power BI.
The short answer is no. A single export action cannot split your data into separate files.
How the export action works
The “Export to File for Paginated Reports” action creates exactly one file each time it runs.
If you pass one ID, you get one PDF for that ID
If you pass multiple IDs, you still get one single PDF, with all results combined into one document
It will not create separate PDFs automatically.
How to generate one PDF per ID
If you want a separte PDF for each ID, you need to handle that in Power Automate.
This is usually done using a simple loop:
Get your list of IDs from a source like SharePoint, Excel, or a database
Use an “Apply to each” loop
Inside the loop, call the export action and pass one ID at a time
Save or send the file for each iteration
This approach is commonly called report bursting.
Important limitation with PPU
Your setup includes Premium Per User, so there is one important constraint.
PPU allows exports, but it limits you to one export every five minutes.
Because of that:
Small scenarios work fine
Larger loops can become very slow
If you trigger exports too quickly, you may see errors due to throttling
Summary
One export action always produces one file
Multiple IDs in one call will be combined into a single PDF
Separate PDFs require a loop in Power Automate
With PPU, the five minute limit can slow down bulk scenarios
If you only have a few IDs, this approach works well. For larger volumes, you may want to look at other options like dedicated capacity or alternative delivery patterns.
✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.
