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
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).
This looks great - but I dont seem to have that option in excel 😞
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 🙂