I found that report larger than a certain size would change from csv to zip format
Do anyone know at what size did the change happen?
It created trouble to me as our corporate email block the attachment with zip format....
I got the answer already.
Data Warehouse automatically zips any file that exceeds 1 MB in size. The maximum email attachment size is 10 MB.