Forum Discussion
Columns order in Power Query vs Table view - exporting to excel from power query
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
gingerclaire Any chance you can provide just a few sample rows of data? I would like to try to determine why the columns might be in the wrong order in Table view.
Is using Analyze in Excel acceptable?
What about using an EVALULATE statement in DAX Query View that essentially does a SELECTCOLUMNS to return the table with the columns in the right order?
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.
Thank you - I have entered the evaluate into the Dax area in PBI which displays the table as is. How to I get it to change the order pls?
It is confidential i'm afraid but it is just drawing from an excel where the columns are in the correct order.
