Getting 256 rows limit from Excel

Like (0) Share

Report

Posted on 6 Aug 2019 15:57:50 by ricardosanchezm

Hi folks,

I have an excel file with 524 records. When getting the records to insert in an sql database I'm just getting 256 limit. I have set the top count to 500, 524, 600 without success. Here is my flow configuration

Could please you check around what is going on?.

Regards,

Categories:

Dataflows

General Questions

All responses (6)

Answers (1)

RezaDorrani 12,141 on 06 Aug 2019 at 16:36:43

Like (0)

Report

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm

Great !!!
ricardosanchezm 86 on 06 Aug 2019 at 16:35:12

Like (1)

Report

Re: Getting 256 rows limit from Excel

Hi @RezaDorrani ,

That's it this option was off in the settings. I thought it was enought to set the top count value and didn't imagine this option existed. Now I can get the 524 as expected.

Thanks!

Regards,
Drrickryp Super User 2024 Season 1 on 06 Aug 2019 at 16:11:51

Like (1)

Report

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm

Depending on your needs, you can use the Static Data connector to bring in up to 15000 records from an Excel file in a few seconds. The resulting table will be read only though.
Verified answer

RezaDorrani 12,141 on 06 Aug 2019 at 16:10:32

Like (0)

Report

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm

have you turned on pagination in settings?
ricardosanchezm 86 on 06 Aug 2019 at 16:05:44

Like (0)

Report

Re: Getting 256 rows limit from Excel

Hi @RezaDorrani ,

I have seen this post before, I have set the top count as it is described in it but the solution is not working.

Regards,
RezaDorrani 12,141 on 06 Aug 2019 at 15:59:26

Like (0)

Report

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm

check this post

https://powerusers.microsoft.com/t5/General-Discussion/256-rows-limit-getting-rows-from-excel/td-p/24092

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly