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

Getting 256 rows limit from Excel

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

flow1.png

 

flowrun.png

Could please you check around what is going on?.

 

Regards, 

1 ACCEPTED SOLUTION

Accepted Solutions
Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

View solution in original post

6 REPLIES 6
Dual Super User
Dual Super User

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/2...

 

Regards,

Reza Dorrani

 

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

ricardosanchezm
Level: Powered On

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,

Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

have you turned on pagination in settings?

View solution in original post

Super User
Super User

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.

ricardosanchezm
Level: Powered On

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,

Dual Super User
Dual Super User

Re: Getting 256 rows limit from Excel

Hi @ricardosanchezm 

 

Great !!!

Helpful resources

Announcements
New Ranks and Rank Icons in April

'New Ranks and Rank Icons in April

Read the announcement for more information!

Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,886)