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?
It is confidential i'm afraid but it is just drawing from an excel where the columns are in the correct order.