Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
VRobbins
Frequent 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 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?

1 ACCEPTED SOLUTION
4 REPLIES 4
vojtechsima
Memorable Member
Memorable Member

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:

vojtechsima_0-1667416333085.png

vojtechsima_1-1667416339492.png

 

 

 

= Table.ReorderColumns(#"Changed Type",{"A", "B", "C", "D"})

 

 
 

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

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.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.