Forum Discussion
Column order within Power Query is not reflected in Model or Datasheet views (bug?)
I think this just has to be a bug. Regardless of what I do, the column order that I define within Power Query is not reflected in either the Datasheet or the Model view. Not only that, but the ...
Hi,
I can confirm that I fixed the issue via the following steps :
1) Diasble Query Load. Ensure Query is no longer showing in the Data Model.
2) Re-enter the Query Editor, Enable the Query Load and Refresh the Query before Closing and Applying Changes.
This will load the query into the data model with column re-ordering preferences intact.
Hope this helps.
Thank you soo much! I have been struggling with this for a long time. Microsoft should fix this though. Load times can be higher with bigger datasets.