Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello:
I have a very simple problem to solve (I think). I need to reorder columns in my table for when I copy and paste it to another program. Right now, I am able to enter into Power Query and move columns as I need to, but when I apply and save and go to Copy Table from the Data pane, the columns are still in their original positions.
I should say that I am using an API, in case that affects anything.
Also, if anyone can point me towards a better way to export to excel than Copy Table, I'd be grateful.
Thank you.
Solved! Go to Solution.
It happens to me exactly as described.
I order the columns for easy understanding into PowerQuery, but in my case, when I close and Apply the changes, everything goes Ok, except for the columns order.
I tried updating twice, changing the order of the reorder command, but was useless... just creating a new query and copy-paste the original query from the Advance query editor, worked for me.
Not sure if by now there is another solution.
Hi @Anonymous ,
Try to add an index column based on the ordering column in the query editor.
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.
@Anonymous daxer? You back?
A response so terrible it solved the problem and was accepted as the solution. Sure.
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
183 | |
92 | |
67 | |
62 | |
52 |