Export data store entity to excel with more than 500 rows

Hello everyone,

I'm kind of stuck in some part of a function I want to create for a certain report. This has to be with exporting the data within the report from data export entity to excel using the a!exportDataStoreEntityToExcel() function. The issue is basically how to export more than 500 rows using this method (or another) to excel since the database only retrieve data in patch of 500 rows. I know I could export to excel patch by patch but I would like to see some approaches for this problem or relevant information that can help me to solve this exporting all the data in just one time. Thanks for your attention and I hope some of you can give me some help with this.