Forum Discussion

Diptesh's avatar
Diptesh
Regular Visitor
8 years ago
Solved

Bug: move column in query not reflected in data view

Hi,    I moved a cloumn "Key" in Query editor to the begining as shown below but the same is not reflected in Data in view.     I found a link that provides a solution to this http://...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi Diptesh,

     

    I'm sorry for misunderstand your issue.

     

    If we want to update the column re-arranged format in Data view. You could follow the steps below.

     

    1.Go to Editor Query and re-arrrange the column and then right click table, untick the option Enable Load.

     

    2. Close and Apply

    3. Click Editor Queries, and right click table, tick the option Enable Load.

    4.Close and Apply and Click Refresh in Data view, then you could see the update column arrange.

     

    Best Regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi Diptesh,

 

I'm sorry for misunderstand your issue.

 

If we want to update the column re-arranged format in Data view. You could follow the steps below.

 

1.Go to Editor Query and re-arrrange the column and then right click table, untick the option Enable Load.

 

2. Close and Apply

3. Click Editor Queries, and right click table, tick the option Enable Load.

4.Close and Apply and Click Refresh in Data view, then you could see the update column arrange.

 

Best Regards,

Cherry

Diptesh's avatar
Diptesh
Regular Visitor
8 years ago

Hi v-piga-msft,

 

Thank you very much. That helps.

 

 

Regards,

Diptesh

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I tried this, using Power BI Desktop Aug 2018. Doesn't work. No matter what I do columns always appear in alphabetical order in Data Window, only on the Edit queries Window do they appear in the correct order (same as in original table). Just another bug in Power BI not fixed properly.