My quicksight dataset is unable to read all the rows from S3 datasource. The dataset was working fine and one day it did not read all the rows which threw off the charts. There was no change made to the redshift query dumping data into S3 and S3 to QS. I’ve tried changing the delimiters, data format but nothing seem to work. Those rows are excluded from error file too.
I can see all the rows in S3 but not just in QS. What can be the cause for this?