Why does my Data Export task fail when export as Excel format with error 'Unexpected error'?
Solved! Go to Solution.
If the Data Export result contains more than 1048576 rows of data and export file type is Excel, the task will fail due to the limitition of Excel. The workaround is export it as a csv file.
Reference from Excel specifications and limits: https://support.office.com/en-us/article/excel-specifications-and-limits-1672b34d-7043-467e-8e27-269...
Total number of rows and columns on a worksheet
1,048,576 rows by 16,384 columns