default date issue

I'm having an issue with my date fields that I can't figure out.

1.  Whenever I pull in date columns, Power BI defaults them as Date/Time columns, rather than Date columns (I'm guessing this is because there's data I cannot see driving this).

2.  Whoever created the program I'm pulling data from set a date field that is left blank to default an output of '12/30/1899'.

3.  If I try to replace the value '12/30/1899' with 'null', it doesn't replace the dates even though an equation is created, because it's expecting to find a time component that's not there.

4.  If I change the column from a 'Date/Time' setting to a 'Date' setting, then seek to replace the value same as before, it works perfectly.

5.  However, when I 'Close & Apply', I get an error.  If I view the error, it shows that the error table is empty.  If I delete the error table that was generated and Close & Apply, I get another error table.  If I leave the error table, it seems to work correctly, but I now have an unnecessary added table on the right of the Edit Query window.

Is this a big deal?  Is there a way to get it to stop 'error-ing' when closing & applying?  Is the date information in the table I've tried to correct updated or "applied"?

Here's a screenshot of the query editor window after I've tried to apply the date column change, gotten the error, deleted the query error group, and attempted closing & applying again to get the error table a second time.

Any help is greatly appreciated!