Increase the Power Apps data row limit from 500 to 2000
By default, Power Apps caps non-delegable queries at 500 rows. Immediate fix: in Power Apps Studio, open Settings (gear icon) > General, find "Data row limit for non-delegable queries," set it to 2000, save, and republish the app — that’s the maximum you can set. Durable fix: tables larger than 2000 rows still lose rows, and loading 2000 rows per screen hurts performance, so make your queries delegable so the data source does the filtering instead.
Where the 500 limit comes from
For any query Power Apps cannot fully delegate, it caps the number of rows it downloads. The default cap is 500. The maximum you can set is 2000.
How to raise it to 2000
- 1In Power Apps Studio, open Settings (gear icon) > General.
- 2Find "Data row limit for non-delegable queries".
- 3Set it to 2000 and save. Republish the app.
Why this is only a stopgap
Raising the limit to 2000 still misses rows on tables larger than 2000, and pulling 2000 rows on every screen hurts performance.
The durable fix is to make your queries delegable so the data source does the filtering — see the delegation guide.