Forum Discussion

Mtozero's avatar
Mtozero
Icon for Helper I rankHelper I
8 years ago
Solved

Data Load error

I tried to load the excel data into Power BI and was getting the error for the columns with value as #N/A and I want to keep the column values as #N/A. How to ignore the errors and load the data. So ...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    In the Query Editor, right-click the column and change the type to Text. Then, right-click again and choose to Replace Errors and replace with #N/A.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
8 years ago

IN query editor, you can use "replace error" with whatever value you want. This option is available on Transform tab, click arrow next to "replace values" and you will find "replace errors" option.