Can we increase the Exporting limit in QuickSight?

Question & Answer
,
1

Hello Team,

Currently I have a table visual which has rows more than 1 million & more than 500 MB because of this limitation not able to export completely.

can someone help me with this whether we can increase the exporting limit so that I can export everything together.

Thanks & Regards,
Deepak Kumar Pradhan

2

Hi @Deepak1,
Are you trying to export data to Excel? Excel has a hard limit of 1 million rows.
Could you do the export in two passes by applying filters and exporting.
e.g. if you have a filter on categories with values A, B, C, D, apply a filter to show A and B and then export. Then reset the filter and filter on C and D, and then export again. Then manually combine the Excel data.
Would that work?
Thanks,
Asem.

3

Hello @Asem ,

Thank you for the quick response, Hope you are doing well!

I mean yes we can do that but just wanted to whether we can increase it or no?

and also there is possibility that if I filter for value A then also the data is more than 1 million in that case it will not work right ?

so currently is it possible to increase or not?

Thanks & Regards,
Deepak Kumar Pradhan

4

If the goal is to save the data in Excel, it won’t work as Excel has a 1 million row limit.
If you wanted to export to csv (that could hold more that 1 million rows), we can create a feature request for that to allow for > 1 million row exports.

5

ok, Thank you for your help and have a great day ahead !!