Removing errors does not work

Hi! I cannot remove certain errors from my dataset in Power Query. I tried removing errors, I tried replacing errors, I tried removing last row (which happens to be the row where the error is), nothing works (see attachment to get a peek at how the dataset looks). Is this simply a bug or is there a workaround?

This is a really common occurrence when you accidentally trigger an error during a change type step, then filter on the column that contains the error. What happens is that the row with the error shows errors all the way across, and the data set gets truncated.

Go back to your FilteredRows1 step and record the row number where your data set ends. Then go back to the (previous) Changed Type step. Check that row to see where the error is.

You need to remove/replace your errors at this point, THEN do your filter and that should resolve the issue.

Hope that helps,

Thank you!