Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

removing empty fields in a column

when i remove empty fields in power query editor i get an error at the top how can i fix that? 

Need Help

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      what do u mean by code? i imported an excel file into power bi. then i hit transform data to make changes  and remove nulls and blanks and columns.

  • 1Daniel993's avatar
    1Daniel993
    Helper III
    3 years ago

    Ok, try not remove the blanks and null, just filter it in the columns. (blanks and nulls don't appear in power bi)

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      oh wow didnt know that thanks. what should i filter it by?

      • 1Daniel993's avatar
        1Daniel993
        Helper III
        3 years ago

        Because maybe you cell (ERROR) depend for some value, so when you filter don't desapear the value and the cell working