Issue with data export from quicksight

Question & Answer
,
1

I want to export a quicksight report of 100,000 records that weighs 4.9MB, when it goes to 30,000 records it is truncated

2

Hi Lorena,
Could you provide a few additional items to help,

  • What output format are you using? Excel, CSV or PDF
  • Is the export of a Pivot Table or Table?
  • How many columns are there?
  • Does it consistently get truncated at the same number of rows, or does it vary?

Thanks!

3

When exporting to Excel there is a limit of 30,000 rows.

Try exporting it to CSV and if you need it in Excel then you can import it from CSV to Excel.

4

Hi @Max @Rahul_Easwar ,

Are there any plans to increase the limit? I believe the current limit for Excel is ~ 40K. Also, what would be the limit for CSV then? ~ 1 million?

Many thanks in advance,
Art