Forum Discussion

zivhimmel's avatar
zivhimmel
Resolver I
9 years ago
Solved

How to remove a field?

Hi,

My question is simple - I need to remove a field because it no longer exists in the underlying database view.

If I just remove it, the next time I try to refresh, it fails because the field does not exist.

What am I missing?

As a temporary solution I've added the field again to the view, but I don't want it to stay if it isn't needed.

Thanks.

Need Help
  • zivhimmel's avatar
    zivhimmel
    9 years ago

    Thanks Sean.

    Actually it turned out that the right thing to do is just to drop the column in the database without making any change in Power BI.

    When I tried to delete a field in Power BI, it got into the transformation sequence that runs when refreshing a table,

    and it would fail because the column doesn't exist anymore, so cannot be removed.

    So it's better to just drop it in the database without changing the model. Then the field would automatically be removed when refreshing.

     

2 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    zivhimmel

    Say you want to do this with Column 2 - delete the highlighted part for the appropriate field in the Query Editor Formula Bar

    then Close & Apply

     

     

    Good Luck! :smileyhappy:

    • zivhimmel's avatar
      zivhimmel
      Resolver I
      9 years ago

      Thanks Sean.

      Actually it turned out that the right thing to do is just to drop the column in the database without making any change in Power BI.

      When I tried to delete a field in Power BI, it got into the transformation sequence that runs when refreshing a table,

      and it would fail because the column doesn't exist anymore, so cannot be removed.

      So it's better to just drop it in the database without changing the model. Then the field would automatically be removed when refreshing.