how to replace error in query editor

[Anonymous]

Hi 

I have excel file that i am loading into PBI. There is one column in that sheet that has incorrect function and gives "#N/A" in excel.

Obviously when i am loading this to PBI it doesnt recognize the format and it gives me errors. However I would like to keep the lines and just replace the error with blank .. because when i try to remove errors i lose the data.

Please can you help 

Thank you 

[jthomson · Accepted solution]

Right click on the column header and there should be a replace errors option...

[soni27]

This is a great option. It will be good idea to add in the Tool bar

[AW1976NOVA]

Thank you.  I didn't know that was an option.

If this is recorded in a step in Query Editor...will the "Replace Errors" step occur in each instance when data is refreshed?

If so, that's an awesome fix.