Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    Right click on the column header and there should be a replace errors option...

jthomson's avatar
jthomson
Solution Sage
8 years ago

Right click on the column header and there should be a replace errors option...

soni27's avatar
soni27
Helper I
6 years ago

This is a great option. It will be good idea to add in the Tool bar