Forum Discussion

TeeGee's avatar
TeeGee
Helper II
6 years ago

Column order within Power Query is not reflected in Model or Datasheet views (bug?)

I think this just has to be a bug. Regardless of what I do, the column order that I define within Power Query is not reflected in either the Datasheet or the Model view. Not only that, but the ...
Need Help
amitchandak's avatar
amitchandak
Super User
6 years ago

Can you share some sample data.

  • TeeGee's avatar
    TeeGee
    Helper II
    6 years ago

    Here are screenshots of the 3 different versions, sorry some are a bit small but if you zoom in you should be able to see none are the same:

     

    Final step of query:

     

    Datasheet:

     

    Model:

     

     

    • v-lid-msft's avatar
      v-lid-msft
      Community Support
      6 years ago

      Hi TeeGee ,

       

      Based on my research,  data fields are always in alphabetical order in Dataset. It's default behavior by design. But you can find a workaroud using [Sort by other column] feature in this post: https://community.powerbi.com/t5/Desktop/Order-in-fields-pane/td-p/45442

       

      The column order can be controlled in Power Query Editor using "ReorderColumn" function or drag the column. But the order of column is only meaningful in the Power Query Editor and will not effect the order in dataset or the field.

       

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • TeeGee's avatar
        TeeGee
        Helper II
        6 years ago

        > The column order can be controlled in Power Query Editor using "ReorderColumn" function or drag the column. But the order of column is only meaningful in the Power Query Editor and will not effect the order in dataset or the field.

         

        I think you must misunderstand what I'm saying, because this simply is not true.

         

        https://datachant.com/2017/01/18/power-bi-pitfall-4/

         

        > The only view in Power BI Desktop where you can see the correct column order is the Data view.

         

        Dong, I see your name contains "Community Support Team", do you work for Microsoft?  If so, I think you should forward this thread to your manager, because this is clearly a bug, perhaps it only occurs rarely, but it's a pretty big deal so I think the developers would like to have access to a situation where it is happening to help them diagnose the underlying problem.