Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Restoring Removed Column Power BI Desktop

Hello,

 

A couple of weeks ago I have deleted a column in Power BI Desktop. Is there a way to restore it?

 

This is one of the columns that I still have in Power Query, it's just missing in Power BI Desktop.

 

thank you!

 

Need Help
  • ChrisMendoza's avatar
    ChrisMendoza
    6 years ago

    Anonymous -

    Go back into the Query Editor and remove the step that was created to remove the column. 

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    In desktop go to

    Edit Queries

    Select the Query with the missing column

    in the Applied Steps pane to the right Find the step that deleted the column you need

    Hover just to the right of it and a red "x" will appear. Click the red "x" to remove that step and restore the deleted column

2 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    6 years ago

    Anonymous -

    Go back into the Query Editor and remove the step that was created to remove the column. 

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    In desktop go to

    Edit Queries

    Select the Query with the missing column

    in the Applied Steps pane to the right Find the step that deleted the column you need

    Hover just to the right of it and a red "x" will appear. Click the red "x" to remove that step and restore the deleted column