Forum Discussion
removing #DIV/0! errors
Hi,
I have a row of 'error' as values across all columns in my query editor page. It corresponds to a #DIV/0! error from a source .xlsx. Despite trying the 'remove errors' function in the dropdown in the upper left (that selects the whole table), or the 'remove errors' function in the 'remove rows' button, or selecting all the columns and right-clicking to the get the 'remove errors' choice, the row of errors still persists. What am I missing?
Some additional context, there was some transformations that were done too, including unpivots and combining multiple excel files.
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing
2 Replies
- Ashish_MathurSuper User
Hi,
Filter any column with errors and uncheck the box for #DIV/0!
- NishantjainContinued Contributor
The "Remove Error" function in Power Query cannot remove errors generated in Excel. Youl will have to remove the #DIV/0 in Excel before importing