When I am exporting a table via (Export to CSV) option in quicksight, it is not generating all rows in that CSV.
I have validated the same by checking the SOURCE json from which it is originating.
Please note: It is less than 500 MBs and 1,000,000 rows.
Hi @Aditya_Arora and good to see you back in the community!
Thanks for confirming that your data is under the 500 MBs and 1,000,000 rows limit in your initial post! I have a few questions/things for you to check so that we can further help you.
Do you have any visual-level filters? The CSV export only includes data that currently displays in the visual. If you have filters applied (including inherited sheet-level or cross-visual filters), the export will reflect that filtered subset, not the full dataset. This is the most common reason for row discrepancies.
(For example: if you have a large table and a filter to only “Chicago”, that will be the only data you get when you export.)
(Here is the exported CSV result).
I would also check for aggregation. If your table has any grouping or aggregation applied, I believe the export will reflect the aggregated rows, not the raw underlying data.
Here is the official AWS documentation, which could be of some help: Exporting data from visuals - Amazon Quick
Hope this helps and feel free to keep us updated by replying to this thread!
Hi @Aditya_Arora,
Just checking back in since this thread hasn’t received a response in a while. Was Cesar’s reply helpful to you and/or were you able to find a solution yourself in the meantime? Please help the community by marking this answer as “Solution” or following up in general within the next 3 business days!
Thank you!
Hi @Aditya_Arora,
Since I haven’t received any further updates from you, I’ll treat this inquiry as complete for now. If you have any additional questions, feel free to create a new post in the community and link this discussion for context.
Thanks!
