cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Eurosiderscalo
Level: Powered On

Export SQL data to Excel with a lot of row

I should export a SQL db to excel online with many lines (like 32.000).

Is there a way to bypassing "row-by-row" process? Maybe by copying the entire sql database or better, create an incremental excel database?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Seb_Dal
Level: Powered On

Re: Export SQL data to Excel with a lot of row

It's not possible to create mutiple row in Excel with Flow but if there is an ID or something like this in your SQL rows, you can use it with a counter and a recurrent trigger to start multiple execution of your program.

And for each execution get 1 or more rows from SQL and add it into Excel.

But for Excel you can only do 100 calls every 60 sec so add in the parameter of SQL and Excel a Timeout and a Retry strategy to avoid error.

And no matter what, for 32 000 lines, it will take around 5 hours to do it.

 

View solution in original post

1 REPLY 1
Seb_Dal
Level: Powered On

Re: Export SQL data to Excel with a lot of row

It's not possible to create mutiple row in Excel with Flow but if there is an ID or something like this in your SQL rows, you can use it with a counter and a recurrent trigger to start multiple execution of your program.

And for each execution get 1 or more rows from SQL and add it into Excel.

But for Excel you can only do 100 calls every 60 sec so add in the parameter of SQL and Excel a Timeout and a Retry strategy to avoid error.

And no matter what, for 32 000 lines, it will take around 5 hours to do it.

 

View solution in original post

Helpful resources

Announcements
firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,676)