Forum Discussion
How to remove error rows ? Remove error option not working
Hi lavdeep,
This one stumped me for a while I was. I would transform data to eliminate errors and it just didn't take. Eventually this is how I solved it:
1) Make sure you are in the Power Query Editor
2) Go to the "Transform" tab
3) Select the column you want to modify
4) Look for "Replace Values", and more importantly, the little down arrow next to it. It's in the sub-section titled "Any Column"
5) Click the down arrow next to "Replace Values" and you'll see another option, "Replace Errors"
If you click that it should produce a dialogue which allows you to replace any errors in that column (or columns, if you select multiple) with a value of your choosing.
Hi lavdeep,
This one stumped me for a while I was. I would transform data to eliminate errors and it just didn't take. Eventually this is how I solved it:
1) Make sure you are in the Power Query Editor
2) Go to the "Transform" tab
3) Select the column you want to modify
4) Look for "Replace Values", and more importantly, the little down arrow next to it. It's in the sub-section titled "Any Column"
5) Click the down arrow next to "Replace Values" and you'll see another option, "Replace Errors"
If you click that it should produce a dialogue which allows you to replace any errors in that column (or columns, if you select multiple) with a value of your choosing.
This solution didn't work for me UNTIL I changed my order of Steps.
I had a Filtered Rows step and if I tried 'Removing Errors' or 'Replacing Errors' afterwards, then it failed.
But when I started applying this step and then Filtering, it worked!
Would love to know why, but in the meantime I'll just enjoy it and stop banging my head against the table 😅
Thank you SOOOO much!
This is the best solution, thank you!
