Discrepancy in Number of Rows Exported to CSV

Question & Answer
, , ,
1

Hi,

I have a visual in my QuickSight dashboard displaying 8,681 rows. However, when I export the data to a CSV file, only 8,664 rows are included. I’ve tried different visuals, and in every case, the number of exported rows is consistently lower than what is shown in the dashboard.

Is there a known row limit when exporting from QuickSight to CSV? Or could there be another reason for this discrepancy?

2

Hi @glopes ,

yes, there is a limit for csv files:

Default limit for export to CSV format: 500 MB or 1M rows whichever comes first

8k rows in your visual is unter 1M rows and the downloaded file is smaller than 500MB. Can you verify the last assumption? How big is the downloaded CSV file?

Do you have hidden fields in your visuals?

Best regrads,
Nico

3

Hey Nico,

My downloaded CSV file is only 3.58 MB and I dont have any hiddden fields. I only have some filters applied.

Is there any settings about it?

4

Hi @glopes ,

The CSV should reflect the data from your visual. Could you try limiting the data in your visual to a smaller set, for example, 20 rows, then export it and check if you can identify any discrepancies between the visual and the CSV?

If the issue persists, I recommend reaching out to the support team by opening a case.

Best regards,
Nico

If this helped you, please mark my answer as solution. That helps the community to find solutions faster.

5

Hello @glopes, were you able to resolve the issue you are facing? If not, is there any kind of similarity in the rows that are being ignored when converting the file to a CSV? I wonder if there is a field that contains some kind of special character, invalid date field, or something that isn’t cooperating with the CSV format.