Why is Power query transform data and the close and load not in the same order?

[Greg]

Hi @Roger

As @Melissa said, the order of the columns doesn’t matter betweeen Query Editor and Data View. The order of the columns also doesn’t matter when appendiing in Power Query/M. If you do want to reset the column order for personal preference reasons, I posted a hack a few years ago that may be of interest:

Tip: How to Change Column Order in Data View

Hi All. I tripped over a small nugget while refactoring a data model and wanted to share. Have you every changed a data source in Power BI and had any new columns display at the end in Data View, rather than in the order you set in the Query Editor? Well, here’s a hack I came across that seems to work: In Query Editor remove the incorrectly ordered column(s), then save changes. You will see in Data View that column(s) was/were removed as well. Now again in Query Editor remove from applied …

Hope it helps.
Greg