You can replace undesirable values with different values by using the Power Query user interface. This approach can be appropriate when there are error values in the data source that you cannot fix. For example, when connecting to Excel, the #N/A values will show up as errors. Unless you can fix the errors in the source, it may be acceptable to replace them with some other values.
Since errors are not values as such, the procedure to replace them is different compared to replacing other unexpected values.
To replace errors:
Right-click a column header and select Replace Errors.
Enter the value you want to replace errors with in the Value box.
Select OK.
You can only replace errors in one column at a time when using the user interface.
To replace a value in a column:
Right-click a column header and select Replace Values.
Enter the value you want to replace in the Value To Find box.
