Power BI Desktop table view ignores Power Query column reordering?

[shawnprodgers]

Hello,

I am trying to understand if what I am expecting is either an error or misunderstanding of excepted outcome. I have a data source with, for example, five columns: A, B, C, D and E.

If I re-order those columns while creating a new query in Power Query to B, E, D, C, and A, I am expecting to see that reordering reflected when I click on the table view in Power BI Desktop after closing and loading that query into Power BI Desktop to start adding calculated columns.

Is this what should happen?

Thank you for your time!

[pqian]

@shawnprodgers the Data Model sorts its columns by alphabetical order