Answered

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

Like (0) Share

Report

Posted on 15 Sep 2017 06:22:09 by HemaR

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.

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

All responses (2)

Answers (1)

HemaR 13 on 18 Sep 2017 at 06:35:55

Like (0)

Report

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.
Verified answer

v-micsh-msft on 18 Sep 2017 at 06:12:22

Like (1)

Report

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