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.
Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.
Click here to read more about the December 2021 Updates!