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