Hi @ssquicksight and welcome to the Quick Sight community!
I’ve included some documentation below that explores ways a SPICE refresh could fail, as well as error codes you may encounter.
I would suggest using this information to test for failure.
In terms of a way to check with a smaller dataset; there’s an error code ‘number_parse_failure’, which occurs if you have a value in a numeric field that’s not a number. You could try adjusting a value in a numeric field early in your dataset.