Data Load error

[Mtozero]

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 that I Can display the  #N/A values in the UI

[Greg_Deckler · Accepted solution]

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]

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.