In Sense Desktop, I tried to export 2M rows in one single column, and it truncated to exactly 1M rows. When exporting two columns, it dropped to 500k rows. With three columns, 333.333 rows.
Can someone please confirm if it limits the export to 1M cells?