Powery Query able to deal with #DIV/0

When I import data from Excel with errors such as #VALUE! the query process will recognise them as errors and when the query is refreshed it will say something like: 10,000 rows returned (8 with errors).

I can then click on this to see what lines are throwing up errors which helps me determine where the underlying data has gone wrong.

However with #DIV/0 it just throws it's hands up and says it can't handle it. I get no, x rows with y errors. Just an error that says #DIV/0 is invalid and the refresh fails.