Unanswered

Performance Speed whilst running a Export to File for Paginated Reports

(1) Share

Report

Posted on by ASleight

I am running a simple Power Automate flow which creates an Xlsm file from a paginated report. the report is a simple table of only 12 Lines rows 6 columns but it is taking 6 minutes to run? is this a normal expectation for Power Automate performance?

Categories:

Using flows

I have the same question (0)

All responses (5)

Answers (0)

Michael E. Gernaey 53,353 Super User 2025 Season 2 on at

Like (0)

Report

@ASleight

We cannot read your words and give you an answer, this is about Flows, you have to share your flow. I get you say words like its simple, but we need to see it, see where its taking the time, show us the flow and show us a Run output, so we can see where all the time is being spent.

Also, go into your details page, and run the Process Mining against it to see if it can tell you where to point too.

If I have helped you, I would really appreciate if you please Mark my answer as Resolved/Answered, and give it a thumbs up, so it can help others

Cheers

Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
RG-25071824-0 on at

Like (0)

Report

I have a similar issue. I'm trying to use a flow to create two types of Paginated Report.

The reports are relatively complex, and query a SQL database. If I go in to Power BI/Fabric and generate the reports, the first might take 15 seconds to generate and the second 1 minute 30 seconds.

The flow passes the variables and runs the reports and puts them in a Sharepoint site. However, the first report (15 seconds in Power BI) takes 1 minute to respond to the app and the second report (1 min 30 from PowerBI) keeps timing out from the app after 2 minutes.

I can do some work to try and make the reports run quicker (e.g. looking at indexing) and I could maybe split up the flow, but is there anything else I should be looking at that I'm missing? I've tried to post a picture of the flow but it won't load - the process mining is showing a red arrow and 8.11m between the "Export to File" using the power BI Rest API to initiate export and the "Create file" to upload the file to SharePoint.

As a last resort, is there a way to extend the 2 minute timeout? We're still in development, but the time-out issue is relatively new - when it was first built, the flow was working without this issue.

Many thanks for any suggestions.

Was this reply helpful? Yes No
swapnildesarda 4 on at

Like (0)

Report

Did you find a solution to this problem? We are having same slowness problem with running paginated report over API.

Was this reply helpful? Yes No
Michael E. Gernaey 53,353 Super User 2025 Season 2 on at

Like (0)

Report

HI folks,

Question: Are you waiting for the Report to be fully rendered before downloading, by polling and then pulling it down.

I still do not see anyone posting their actual flows so we can review them.

Was this reply helpful? Yes No
swapnildesarda 4 on at

Like (0)

Report

Yes, its a 3 API process. Start the report export, get the status and when complete, get the file. Its explained in

https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to

Did you solve the performance issue?

Was this reply helpful? Yes No