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.
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.
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.
Yes, I have a Premium License and data is there 1 lac
how many rows of data? Do you have a Premium license for your SQL connection?