When exporting a query, you might notice that the Excel file has fewer results than the query. The maximum number of records in an export by default is 100,000. However, this value can be set in the web.config file.
To change the maximum results in an export file, open the web.config file. In the <appsettings> section of the file, add the following line: