Refresh Errors - Missing data (date)

[PGAT]

Hi, I will appreciate your help on this.  I have several tables, and in it, I have gotten to a refresh error due missing date in the columns.  How can I refresh and 'skip' these errors?  It is not exactly errors. There are just no dates for it. 

Thanks. 

[Nolock · Accepted solution]

Hi @PGAT,

you can use the Remove Errors functionality of PowerQuery Editor - see the screenshot.

You can also replace all errors with another value with Replace Errors... - if needed.