Forum Discussion

Louiselam's avatar
Louiselam
Frequent Visitor
7 years ago
Solved

How to add back the removed column from Sample file?

Hi,

 

I have uploaded a folder , and with sample file setup. Have removed some of the column during sample file setup. But now realise I need those column in my dashboard.

 

Is there any method to add back the removed column without having to rebuild the whole thing?

 

thanks

Need Help
  • v-cherch-msft's avatar
    v-cherch-msft
    7 years ago

    Hi Louiselam

     

    You may click 'Edit queries' under 'Home' bar and then Click 'X' to remove the 'Removed columns' step.Then the data will get back.

    Regards,

    Cherie

2 Replies

  • v-cherch-msft's avatar
    v-cherch-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Louiselam

     

    You may click 'Edit queries' under 'Home' bar and then Click 'X' to remove the 'Removed columns' step.Then the data will get back.

    Regards,

    Cherie

  • reza_rad's avatar
    reza_rad
    Icon for Advocate IV rankAdvocate IV
    7 years ago

    as v-cherch-msft mentioned, go back to Power Query Editor to do it. But if you just want to return back some of those columns, not all deleted columns, then after removing the "Removed Columns" step, you can select those that you don't want and remove them again. then Close & Apply.