Reference: Modeled Sheet Size Limitations
Modeled Sheet Rows
Modeled sheets support a maximum of 500,000 rows. Once the sheet reaches 500,000 rows, you can't import more rows or manually add rows.