The following error occurs during EXPORT for SSRS to CSV for a large data set:
Number of rows exceeds the maximum possible in a worksheet of this version.
SSRS does not natively export CSV. InfoBurst extracts Excel then converts it to CSV. The error results from InfoBurst requesting .xls instead of .xlsx. InfoBurst 2021.2 will switch to requesting .xlsx to resolve the issue.
This issue is addressed in InfoBurst 2021.2.
InfoBurst 2021.2.4 - Release Notes