Forum Discussion
Solved
Columns order in Power Query vs Table view - exporting to excel from power query
Hi I have a huge data set (about 200,000 rows) that we used to have to manually run various fixes and finds and replaces in excel (it drove me insane). I have finally been allowed to access this d...
UPDATE: I found this on a different forum which seemed to work!!
There is easy fix to enforce column order in Power Query:
- In Power Query Editor > Disable Query Load. Close and Apply.
- Open the Query Editor again, enable the Query Load. Refresh the Query. Then Close and Apply.
Link to original is here: https://stackoverflow.com/questions/54354205/trying-to-reorder-columns-in-data-view-in-power-bi
Greg_Deckler, I've see this discrepancy in order before when I add a new column in Power Query. That column usually ends up as the rightmost column when the table is loaded even if it's not in the query editor. It feels like it has some kind of column schema that it updates rather than rebuilding.
Its so frustrating as there are no calculated columns - its just pulling form an excel that is in the correct order. All I am doing is a selection of F&R in power query.