Unanswered

Slow performance when writing many rows with SQL/For Each actions

(0) Share

Report

Posted on by Kresimir_RPA

286

I'm developing a process in which I'm pulling some data from database and writing that data into Excel table. All the work is done with SQL actions and then I'm using For each action and executing row by row into the excel table also with SQL actions.

There are about 100 000 rows, sometimes more. The problem is that it takes too long. Writing 10 000 rows takes about 13min.

Is there some reason why is this taking so long, maybe some limitations of how many actions or requests are there in the flow, maybe some Power platform licence add on limitations restrictions?

We're using premium licence with unattended add-on.

The same process previously ran on the Softomotive platform and ran 10 times faster.

Kind regards,

Krešimir

Categories:

Power Automate Desktop

I have the same question (0)

All responses (2)

Answers (0)

Agnius Bartninkas Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

PAD is slower than WinAutomation/ProcessRobot, that's a known thing and there's no surprise here. First of all, it connects to the cloud and logs every single action of the flow in there, so that's slowing it down. It is also presumably built on a slightly slower engine.

Maybe try using Excel actions instead of SQL actions to write, as Write to Excel worksheet allows writing entire data tables at once. You will not need to loop through the data table to do it.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

Was this reply helpful? Yes No
lbendlin 8,649 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Another option to consider is the Graph API where you can do bulk writes into Excel tables.

Was this reply helpful? Yes No