Forum Discussion
Column order within Power Query is not reflected in Model or Datasheet views (bug?)
Hi TeeGee ,
I apologize for misunderstanding your situation, Now I have resized my answer:
Firstly I think you have konw that the column order in Model View and File Pane will be in alphabitbetical order and can not be effected by order in Power Query Editor.
So the left problem is the order in Data View and Power Query Editor, The article you provided in the first mentioned that:
You can control the order of columns in a table in the Power Query Editor but it’s not completely straightforward to get any changes to column order you make in your queries to be applied to the order of the columns in a table after it has already been loaded into a dataset.
The workaround in this article works fine on my side.
1. Change the column order in Power Query Editor
2. Apply changes
3. Disclick "enable load" and Continue
(Notice that will break any visuals that use this table any lost all measures or calculated columns associated with this table.)
4. Apply changes
5. Click "enable load"
6. Apply changes
7. Refresh the data.
I guess this workaround have no effect because you miss the step 4 ?
The reason why data view cannot read the order defined in Power Query Editor automatically seems hard to understand , If the workaround still useless on your side, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/
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.
> I guess this workaround have no effect because you miss the step 4 ?
Well yes, because that will break any visuals that use this table any lost all measures or calculated columns associated with this table.
It's fairly useless to be able to reorder columns in PQ if it isn't reflected anywhere else in the model. It's mind boggling that this standard behavior isn't available in Power BI.
Hi TeeGee ,
The previous workaround has some problem, you can try the following.
1. Open Power Query Editor
2. Edit the column order
3. change the table name to such as table1-copy (DO NOT APPLY CHANGE)
4. create a blank query, name as the previous table name (and make query = table1-copy)
5. apply the changes
6. check the visual about this table, if anything loss, do not save the file
7. each time change the column order, do the 1-6 again. keep the origin table and delete the blank query
Best regards,
Community Support Team _ DongLi
If this post helps, then please consider Accept it as the solution to help the other members find it more