I am getting errors while exporting large data to Excel. How can I correct the problem?
Increase the maximum rows to 100000 for Excel reports. You can also extract larger reports by having the KPI scheduled as a Scheduled KPI and publishing/constructing the resultant objects via XML. By this method, we can extract larger reports in excess of 100,000. Also, pagination of data can also be enhanced based on the requirement to extract large data. If you require any further help, contact the support team.