Rows scanned from the source tables were skipped

Question & Answer
, , ,
1

I have a dataset which is a custom SQL left join to a csv file. Every time when I refresh the dataset, the dataset status shows completed.
image

However, when it comes to reporting, it shows some rows were skipped. What are the reasons some rows get skipped? I do notice that there are missing values on my report. Thanks so much for your time in advance.
image

2

Hello Yunchen,

It could be related with the CSV file that is being joined and may have inconsistency in field and its data types.

May be try to see if this helps - Troubleshooting skipped row errors - Amazon QuickSight

Hope this helps.
Cheers,
Deep

3

Thank you for letting us know. I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!