Comments
For example, I am configuring pivot excel analyses report for the customer that has more than 3000 new lead records on daily basis. I have created the report/analyses and uploaded as template so that the users can download it any time and see the analyses. They need to have the same analyses on the monthly or quarterly level but the record number exceeds the maximum of number of columns for 100K rows is 5 columns i.e. 500000 cells. The report combines data from 2 tables, so I am not able to use data platform import option. Even if I could, it would not be user friendly option for the end users. If I use data flows to fill the excel I would still hit the maximum record defined by Excel .I hope this use case will help you to think of a better solution when it comes to excel data export .