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 steps the action that removed the column(s), then save it again.
- You will see in Data View that the previously removed column(s) was/were added to the end of the table.
Shout-out to trololo for posting this; see the 9th post in this thread: