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
Go to 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.
View solution in original post
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.
Proud to be a Super User! Appreciate your Kudos 🙂 Feel free to email me with any of your BI needs.
Click here to read more about the December 2021 Updates!
Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.
Mark your calendars and join us for our next Power BI Dev Camp!