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.

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
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.