Forum Discussion
how to replace error in query editor
Hi I have excel file that i am loading into PBI. There is one column in that sheet that has incorrect function and gives "#N/A" in excel. Obviously when i am loading this to PBI it doesnt recog...
Right click on the column header and there should be a replace errors option...
Right click on the column header and there should be a replace errors option...
Thank you. I didn't know that was an option.
If this is recorded in a step in Query Editor...will the "Replace Errors" step occur in each instance when data is refreshed?
If so, that's an awesome fix.
This is a great option. It will be good idea to add in the Tool bar
