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
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?
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?