Forum Discussion
Data View column order change
I created this Idea - Aug 24, 2015
Still waiting...:smileysad:
I found a sollution. It is quite wierd, but it works.
Remove columns in Power Query view. save and apply changes. Then go back to power Query view, delete the removed Columns Steps in the desired order, and then your columns in Data view will be reordered.
Data view shows the last changed column last. That is the basic concept behind this trick.
Check out this link for more details:
https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi
I was typing this out and realized you had posted the same thing. I upvoted and will put my reply underneath so it can get more traction.
This is a rather silly solution, but it did work. It may be a bit more cumbersome if you have a wide range of columns.
My table had five columns. My column three moved to the end and became my new number five. Therefore, my old four and five became my new three and four. I thought to myself. What if I just delete those columns from the table and go back to my editor and remove that last step that removes them from the query steps. Well, that worked. Now all columns, three, four, and five, are back to where they should be.
