Forum Discussion

Razorbx13's avatar
Razorbx13
Icon for Post Patron rankPost Patron
6 years ago
Solved

DataFormat.Error #N/A and #DIV/0!

I am bringing in an Excel file source that is generated from an export in an application and some of the fields have this in the extract, #N/A and #DIV/0!.  They are not formulas, just text in a fiel...
Need Help
  • negi007's avatar
    negi007
    6 years ago

    Razorbx13  In power Query window, use replace error to replace error with a default value

     

     

  • Razorbx13's avatar
    Razorbx13
    Icon for Post Patron rankPost Patron
    6 years ago

    No this does not work, the error is still there.  There error is DataFormat.Error: Invalid cell value '#N/A".

    • negi007's avatar
      negi007
      Icon for Community Champion rankCommunity Champion
      6 years ago

      Razorbx13  In power Query window, use replace error to replace error with a default value