[Sheets] exceeds maximum allowed row count of 100k

[jeremy_tran1]

Hi team,

We are facing a new error when trying to add a Table (Sheet) with more than 100k rows.

We didn't find this lmitation on the helpcenter https://help.appsheet.com/en/articles/1106364-limits-on-data-size.

Do you have any new limitation on Sheets ??

thanks

[diogolupcosta · Accepted solution]

You can fix it adding the table with 99,999 lines and then put the other lines.

[SkrOYC]

From other's experiences about this, it's an actual limit of the platfor and seems related to the worksheet. In other words, SQL should work fine.

Also take into account that this amount of rows is probably unneeded for an AppSheet app.

Anyway, it's a known problem that won't be solve anytime soon.

BTW, what's your source exactly and how many columns are there?

[diogolupcosta · Accepted solution]

You can fix it adding the table with 99,999 lines and then put the other lines.

[Koichi_Tsuji · Accepted solution]

Delete rows first from your table, but leaving just few rows. Then add this sheet as table for appshet.

Then un-do delete opration on the sheet. 

Sync form appsheet.  

Should throw no errors

@takuya_miyai 

[SkrOYC]

It should, although I heard from others that they were having problems anyway.

I think at least he can try 🤔

[Koichi_Tsuji]

It should work.