Views:

What’s happening?

Users are unable to export more than 100,000 records at a time using Excel.

Reason:

By default, Power Apps has a limitation that restricts exporting to a maximum of 100,000 records at a time when using Excel.

Resolution:

To export more than 100,000 records from Excel, you can try exporting smaller batches: 

  1. Use the built-in filter function available on entities to reduce the number of records.
  2. Export the records partially by applying filters to divide the records into smaller segments (e.g., half, thirds, or quarters).
  3. After successfully exporting one batch, adjust the filter criteria to export the next batch of records.

See Export to an Excel dynamic worksheet in model-driven Power Apps - Power Apps | Microsoft Learn for more information on using Excel for data exports.

Additional options for exporting data from Dataverse can be found at Importing and exporting data - Power Apps | Microsoft Learn.