Query edits to reorder columns not displaying in table

[mcray11]

I'm a very new user but have hit a roadblock. I've made edits to a simple table in the Edit Queries window to remove some columns, rename a column and then reorder the remaining columns. I've tried these steps in different orders as well, however regardless of the order of query edits, the columns in my table will not reorder.  

What am I missing to allow the columns of the table to be put in a different order?

[greggyb]

There's no way to reorder the columns in the data view based on changes made in the Edit Queries (Power Query) portion of Power BI.

The field list in the report designer will be alphabetical anyway, so it's not really worth spending much time worrying about this. The interactivity in the Data view is only to sort by various columns, anyway.

[mcray11]

Ok, thanks. I misunderstood that functionality. I was trying to order my columns to be able to use a Union function to merge two tables.  As is it does not correctly join the two tables.  But it looks like I should make that change in the source data.  Thanks for the quick response!

[greggyb]

You can perform a union in Power Query, with the Append functionality. In general it's better to do this sort of transformation before data is imported to the data model.