Power BI Transform Data column order changes when loaded

[VRobbins]

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 column (reference) toward the right near the end.  How can I get my columns to stay in the order I like instead of moving them all over the place?

[vojtechsima]

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]

Already tried that and when I save and load the table is all rearranged back like PBI arranged before. 😞

[Analystmate · Accepted solution]

Check out this :https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi

[VRobbins]

Thank you for posting. Good resource. First scenario won't work because it puts the desired column at the end and I need it to be first. Second scenario I received a message that it will disconnect from all connections in my report and I have too much time invested already for that to happen.  Third scenario looks like it may work, but my table has over 40 columns so I will try when I have time to manually list them all.