Is there a limit in the number of rows ina csv file?

Question & Answer
, ,
1

I uploaded a csv file with 165848 rows but its only showing 19,773

2

Hi @husbarak,

Thank you for posting.

Amazon QuickSight supports exporting up to 1 million rows or 500 MB of data, whichever limit is reached first. Kindly see documentation here

Regards,
Demola

1 Like
4

Hi @husbarak

When you upload a file, it will directly load into the SPICE memory. Can you check if you have enough capacity to import the dataset?

Else you can change that to Direct Query and save the csv.

Else If you don’t have enough SPICE capacity, you can choose to make the dataset smaller using one of the following methods:

  • Apply a filter to limit the number of rows.
  • Select fields to remove from the dataset.
  • Define a smaller range of data to import.

(Preparing a dataset based on file data - Amazon QuickSight)

1 Like
5

Hi @demola, did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!