Why Quicksight is loading only half of the data from a csv file

Question & Answer
,
1

Hi Team,

I had 66k records on my CSV file , i tried loading directly as it is from file upload, also tried uploading to quicksight from S3, but in both cases its loading only 30.5k records. I dont see any validation error, it says 95% completed loading! It also skipped 1.5k rows but still its not really matching the actual 60k records.

2

Hi @kodimalar.sakthivel - To trouble shoot import errors, better to collect request ID and raise a ticket to AWS Customer support team so that they can analyze the error for that request id from back end. To raise the request, please follow the below link - Creating support cases and case management - AWS Support

Regards -Sanjeeb