GuidesIncrease the Power Apps data row limit from 500 to 2000
Power Apps
Increase the Power Apps data row limit from 500 to 2000
By default Power Apps only retrieves 500 rows for non-delegable queries. Here is how to raise it to 2000 and why that is not a real fix for large tables.
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.