You’re offline. This is a read only version of the page.
Hi,
I have created a flow that inputs some parameters into a paginated report based on my SQL query and exports a single PDF per row (about 3000 rows). As you can see the bottleneck stems from the paginated report connector. This flow took 1 Minute and 4 seconds and only generated 3 PDFs. Is there any way to make this faster, Limitations I should be aware of, or is just something I am doing wrong? Any help would be greatly appreciated!!!
Upgrading to Premium capacity would improve the performance - I wouldn't go as far as saying that it would definitely solve the problem. Whenever you ask for a report export every single page (that you request) needs to be re-rendered. This is a costly operation for regular reports, and even more so for paginated reports that produce pixel perfect results. Having parameters involved may or may not make things worse.
Ideally your data source is in import mode (so you get the guaranteed performance of a Power BI dataset) or your Direct Query data source is optimized for the queries produced by the renderer (including the parameter filters).
There are a lot of moving parts, and most of the complexity is hidden from you behind that innocent little "Export to File" action. So whatever you can do to reduce the computational load will make the process more robust and more performant.
In an ideal world you would not need to do these exports. Yes, I know, rather unlikely to be an option.
Thank you for your response, it looks like I am on a shared capacity.
The query that drives the dashboard report loads about 52,000 rows and then the user filters to the parameters they would like the connected paginated report to export as seen below, do you mean try and simplify this query?
would upgrading our PBI subscription to allow premium capacity settings solve this problem to the best of your knowledge? Thanks again!!
Is this running on Shared or Premium Power BI capacity? If on premium and if available you can speed things up by moving the workspace to a higher level SKU (from a P2 to a P3 for example).
You can also speed things up by making your report more nimble. Fewer visuals, simpler queries etc.
#1
Tomac
986
Moderator
#2
stampcoin
699
Super User 2025 Season 2
#3
Riyaz_riz11
577
Super User 2025 Season 2
Share
Report
All responses (
Answers (
