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
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi Diptesh,

 

 But i think the option given in the tool to rearrange the columns should work seamlessly wihout any issues.

 

can this be reported as a bug and fixed in upcoming releases? i am currently using the June release 

 

This is not a bug, it is by design. We could only move the column in Query Editor then apply it to Data view.

 

In addition, you could vote this similar idea in Power BI idea Forum.

 

Best Regards,

Cherry

  • Diptesh's avatar
    Diptesh
    Regular Visitor
    8 years ago

    Hi v-piga-msft,

     

    The issue here is that the columns re-arranged or moved using the query editor are not reflected in the Data View once i click close and apply. Please refer to screen shot in my first post.

     

     

    Regards,

    Diptesh

    • v-piga-msft's avatar
      v-piga-msft
      Icon for Resident Rockstar rankResident 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

      • Viren's avatar
        Viren
        Regular Visitor
        7 years ago

        Hi v-piga-msft 

        About this issue - using the below solution is easy when the user has not used the table in any visualisation or measure. I'm also facing a similar issue however, column arrangement shown in power query mode is not the same in Data view. and it's not allowing me to create a new relationship and giving circular reference error. Also, I can not use the below solution as I've already designed my entire Report using another database (with 100+ measures) and using the same as a template to replicate for other databases in the organisation. 

         

        do we have any other option to deal with this issue? 

         

        Thanks in advance!