Forum Discussion
Unable to Remove Errors
I have a table which contains time-series data. I have errors appear in some rows, however don't seem to be able to remove them. I have tried Remove Errors, Replace Errors and Replace Values. I've ev...
I have solved this by moving the Table.RemoveRowsWithErrors() function to an earlier point in my Power Query, where the errors appear as single cells in one column (rather than expanded out to an entire row).
I have solved this by moving the Table.RemoveRowsWithErrors() function to an earlier point in my Power Query, where the errors appear as single cells in one column (rather than expanded out to an entire row).
Same for me. Tried remove, replace errors, identifying them with try, etc. The Table.RemoveRowsWithErrors() function needs to be immediately after Source. Any later and it will not work.
This works . . .Removing Errors immediately after Sources fixes the problem. Thank You.
