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 recognize the format and it gives me errors. However I would like to keep the lines and just replace the error with blank .. because when i try to remove errors i lose the data.

 

Please can you help 

 

Thank you 

Need Help
  • jthomson's avatar
    jthomson
    8 years ago

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

3 Replies

  • jthomson's avatar
    jthomson
    Solution Sage
    8 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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.

    • 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