Forum Discussion

solvit1421's avatar
solvit1421
New Member
7 years ago
Solved

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. 

  • solvit1421 

     

    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

  • Nishantjain's avatar
    Nishantjain
    Continued Contributor

    solvit1421 

     

    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