Datagrid 2 - Huge Data Load Issue

We are using Mendix 10.2 version and using Datgarid 2 to load data from the table. We are using microflow to fetch the records and show in the grid. When we load more than 1000 records, we are unable to set the data instantly and also export to excel is not working.
1 answers

The export to Excel button has a row limit parameter, which can be set to maximum of 65535 rows.

I would always suggest to pass a pagination entity as parameter to the microflow to limit the amount of rows to one page at a time. Mendix can create the necessary entity and nanoflows for it.