Forum Discussion

Ehab's avatar
Ehab
Regular Visitor
8 years ago
Solved

how do you remove columns in query editor

I imported an excel sheet with many columns   it's easy to select the columns i want in Report view, but in Query Editor  it shows all of them. how can they be in sync so whatever columns i see in ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Ehab,

     

    1. If you want to delete some columns, you can also do it in the Data or Report pane.

    2. There is a view of all the columns in the Query Editor. 

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

In Query Editor, right-click the columns that you do not want and remove them.