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 doe...
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.

     

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.