Forum Discussion
Reordering Columns in Power Query not Reordering in Data View
- Just to be clear on your process, you are reordering your columns in Power Query, saving and closing, refreshing and then in Desktop you right-click the table and choose Copy Table?
Just one item on this as a comment. I have seen column reordering steps add a considerable amount of time for refresh. So, once you get this sorted out I would highly recommend removing that step as it is kind of useless in general.
LUCKILY for you guys - ALL you have to do to fix this bug is go to Advanced Editor of the Query that is not re-ordering correctly. Copy the Text version of the query. Create a new blank Query, copy and paste the broken query's text into, refresh the query, and then delete the old one.
Your new query will have the right order - this has something to do with cacheing possibly - but renaming the query and clearing caches + restart did not fix it for me... Only re-creating the query worked.
This solved the issue for me as well.
No matter what I did to change column order in the Power Query Editor, they didn't update in Table view. Restarted the app, nope. Saved under a new file name, nope. Refresh, nope. Nothing worked.
Then all I did was copy the query string from advanced editor, re-imported the data and pasted the exact same string into the advanced editor and when I got back to table view my columns were now ordered properly.