256 rows limit getting rows from excel

[AmitLoh-Powerap]

256 rows limit getting rows from excel. I am not able to get more than 256 rows from excel located on ftp in flow. I have 400 rows in excel. It only gives me 256 rows.

[Framil_A]

Awesome! Works like a treat! Many thanks @Nikolaos 

[MBates]

When I change my pagination settings and save my flow, I get this:

Flow save failed with code 'DynamicOperationRequestClientFailure' and message 'The dynamic operation request to API 'excelonlinebusiness' operation 'GetTable' failed with status code 'NotFound'. This may indicate invalid input parameters. Error response: { "status": 404, "message": "The requested resource doesn't exist.\r\nclientRequestId: 9bb069e3-50bf-4964-ab1e-0536108b433f\r\nserviceRequestId: a4d38db2-c560-45c1-bd0e-159aefa2edb3", "error": { "message": "The requested resource doesn't exist." }, "source": "excelonline-cus.azconn-cus.p.azurewebsites.net" }'.

[sajarac]

Hello MS Guys.

Quick question. I am trying to copy my giant excel file "close to 1M rows by 12 columns" I have a combination of Text and Date columns".

Could you please let me know How many hours this operation will take? and also is possible to copy all those rows? or only the maximum threshold of 100000?

[Powerplatform01]

@AmitLoh-Powerap 

Refer this video to resolve your issue.Also request you to please subscribe this channel

https://youtu.be/HFghBAYX-oQ

[sajarac]

Hi @Nikolaos , just curious. How many hours took for this operation to be completed?

[Nikolaos]

Hi there, 

i am really sorry to say that I truly don’t remember but I don’t think it was more than a few hours. 3-4 maybe. 

hope it helps you

[sajarac]

Thank you very much for your prompt response. I will continue investigating.

[sajarac]

Just FYI.

Unbelievable. 8 Hours for 8,000 rows. !!!

[KennyTheFarmer]

I just struggled with the same 256 row limitation.  Changing the pagination settings allowed me to load all rows.  Thanks for the solution.