web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Any way to speed up flow?
Power Automate
Unanswered

Any way to speed up flow?

(0) ShareShare
ReportReport
Posted on by 3

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!!!

 

xti224_0-1672254311607.pngxti224_1-1672254336304.png

 

Categories:
I have the same question (0)
  • lbendlin Profile Picture
    8,661 Super User 2026 Season 1 on at

    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.

  • xti224 Profile Picture
    3 on at

    Thank you for your response, it looks like I am on a shared capacity.

    xti224_0-1672262166780.png

    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?

    xti224_1-1672262648654.png

    would upgrading our PBI subscription to allow premium capacity settings solve this problem to the best of your knowledge? Thanks again!!

  • lbendlin Profile Picture
    8,661 Super User 2026 Season 1 on at

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard