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!
