Forum Discussion
VRobbins
3 years agoFrequent Visitor
Power BI Transform Data column order changes when loaded
My Power BI report imports data from an Excel workbook and during the transform data my columns are in the order I like them. When I save and load, Power BI re-orders my columns and moves my first c...
- 3 years ago
Check out this :https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi
vojtechsima
3 years agoSuper User
Hi, VRobbins ,
That's very strange, you can try to enforce the order by first dragging one column to certain position, then new step will occur and in that, you can adjust the position as you want and then try to load it:
= Table.ReorderColumns(#"Changed Type",{"A", "B", "C", "D"})
VRobbins
3 years agoFrequent Visitor
Already tried that and when I save and load the table is all rearranged back like PBI arranged before. 😞