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
Hi gingerclaire ,
As a workaround, you can add an index column in power query and export it in batches. For example, for the first time, the data from indexs 1 to 100,000 is filtered and then exported from table visual. The second time, the data from indexs 100001 to row 200,000 is filtered and then exported also from table visual.
Then you can append the two sets of data that have been exported.
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks - sorry but it only lets me export 1000 at a time (not 100,000) so i would have to do that lots of times. 😞