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 ...
Just to make a note for future reference where a static table source is a spreadsheet ...
. change spreadsheet
. refresh dataset on the Service
. take a copy of the dataset
. in the transform (Power Query Editor), uncheck the query 'Enable load' (right mouse menu)
. apply, close & apply the transform (Power Query Editor)
. the table should now be removed/missing from the data model
. open the Power Query Editor
. against the table query, check the query 'Enable load' (right mouse menu)
. refresh the query
. apply, close & apply
. refresh
> the static table in designer should now reflect both the original spreadsheet and in Power Query
