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
Can you copy the query from Power BI to Excel? That seems like the easiest thing.
If you need to pull from Power BI, I'd recommend the Insert Table option in Excel (announced here and here). There is a row limit but you can modify the DAX query that builds the table to remove that constraint and load as many rows as Excel supports (a bit over a 1 million).
I still havent found a solution and it seems craxy to have to 'fix' the data after I export it (when I embarded on this to tody it up).
I have never used queries in Excel, so if you were able to provide any assistance on this I would be very grateful 🙂