Announcements
I want get on prim SQL data from SQL to SharePoint document library in Excel through power automate. There is any steps or solutions or helpful article. Please suggest any best solution.
how many rows of data? Do you have a Premium license for your SQL connection?
Yes, I have a Premium License and data is there 1 lac
My guess is that the best you can do is about 200 rows per minute. You do the math with 100K rows...
Look for a different tool/process.
@lbendlin @pankajIND
This template can get up to 1000 rows per minute & with far fewer action api calls: https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Excel-Batch-Create-Update-and-Upsert/td-p/1624706
You would need to switch out the example Excel sample with your SQL connector & replicate the skip & top logic from the Excel connector to the SQL connector.
And for that amount of data I’d suggest the version b flow with a do until loop.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Haque 604
Valantis 502
Vish WR 417
