Spice import shows skipped rows with now explanation

When spice refreshes and imports the rows it shows rows skipped/ in the view error summary there is not explanation to why are they skipped. how do i know where they are and how to fix them.
Screen Shot 2021-12-13 at 13.24.59

If you click “view error summary” and then “download error rows file”, you can download a file that has a row for each error. The “ERROR_TYPE” column shows the error codes that explain the reason.

For description of the error codes, please refer to: Error Codes for Skipped Rows - Amazon QuickSight

Troubleshooting Skipped Row Errors - Amazon QuickSight has more details.

hi, i don’t have the option to download error rows file. where is it?

Any ideas on how to continue from here?

Hi,

QuickSight has run into an unknown error while ingesting your data and with this particular error you are unable to download an error rows file. The best course of action is to create a support case in the Support Center and share details of your dataset so one of the engineers can take a closer look at what is happening in your environment.

Awesome, thank you so much for the answers!