Forum Discussion
Mtozero
Helper I
Helper IData 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 that I Can display the #N/A values in the UI
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.
2 Replies
- parry2k
Super User
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.
- Greg_Deckler
Community Champion
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.
