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 dropdow...
Need Help
  • Nishantjain's avatar
    Nishantjain
    7 years ago

    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

     

Ashish_Mathur's avatar
Ashish_Mathur
Super User
7 years ago

Hi,

Filter any column with errors and uncheck the box for #DIV/0!