How do handle 1M rows in Quickisght

Question & Answer
,
1

I have imported an excel dataset in spice which contains 1M rows. But when I try to create any visual (especially Table or KPI), it is stuck on loading mode and no data is visible. I am unable to create any control as well.

Can you please help in getting to know any method to handle 1M rows ? What if such data is encountered what prior steps should we take before importing them on Quicksight?

Please Note : Currently data is in excel mode and saved on local system (not on S3)

2

Hi @shivazr

When working with large Excel datasets (like 1M+ rows) in QuickSight, please note that the Excel file must be 1 GB or less to be uploaded directly. For better performance and scalability, we recommend converting the file to CSV or Parquet format and uploading it to Amazon S3 before importing into QuickSight. This ensures smoother loading, better compatibility, and avoids issues with large file limits.

Please refer to the following documentation this might be helpful for you.

1 Like
3

Thanks @Xclipse, this was helpful.