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

How to increase the number of rows instead of 2048 rows while importing excel data to SQL tables ?

I'm building a flow to import the rows from excel file to SQL tables once the excel file is modified or created newly from a Onedrive folder. The excel file has more than 10000 rows. Created flow runs successfully but it imports only 2048 rows though excel files has more than 10000 rows. I'm using 'Get rows' action and specified explicitly to take 100000 records. After 'Get Rows' action, I'm using SQL - Insert Rows action to dump the rows to SQL Staging Table.

 

q.png

 

Can somebody help me resolve this issue to get all > 10000 rows from excel ?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: How to increase the number of rows instead of 2048 rows while importing excel data to SQL tables

Hi @HemaR,

 

2048 rows is the current limitation for Excel Get Rows action, see this thread for reference:

Re: 256 rows limit getting rows from eccel

Response from staff Suresh:

"

Recently we increased the Max rows limit to 2048 but the default limit is still 256. 

"

For more information about the Excel connector, check:

Excel

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Community Support Team
Community Support Team

Re: How to increase the number of rows instead of 2048 rows while importing excel data to SQL tables

Hi @HemaR,

 

2048 rows is the current limitation for Excel Get Rows action, see this thread for reference:

Re: 256 rows limit getting rows from eccel

Response from staff Suresh:

"

Recently we increased the Max rows limit to 2048 but the default limit is still 256. 

"

For more information about the Excel connector, check:

Excel

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HemaR
Level: Powered On

Re: How to increase the number of rows instead of 2048 rows while importing excel data to SQL tables

Hope it would get increased in future. Thanks for the response.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 Release Wave 2 Plan

Power Platform 2019 Release Wave 2 Plan

Features releasing from October 2019 through March 2020

thirdimage

Flow Community User Group Member Badge

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

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 Flow Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 257 members 4,791 guests
Please welcome our newest community members: