Forum Discussion
BUG: Reorder.Columns?
Once the data is loaded to the data model, changing column order in Power Query does nothing. The only fix is to unload, apply, and reload the table. Of course, that will destroy any calculated columns, measures, visuals, and filters you were using. I don't know if that is a bug as much as it is a design issue.
In designing reports though it doesn't really matter. When choosing fields in both the Report and Model views, they are alphabetcial. You only see this issue in the Data view, which I try to stay out of anyway. I avoid calculated columns as much as possible.
Hello Alex_Ooi
so you did try my solution that i proposed to
- leave your query as it is, but passing for refreshing purposes a table one new column onl (add new final step that procudes a table with one column only)
- update datamodel (now with errors, because of the missing columns)
- delete final step to pass your query
it would be interesting to know if this could solve your issue
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy
Hello Alex_Ooi ,
I'm not 100% sure but I think once handed over to the datamodel, the order of the columns are not part of the interface, meaning that only columnNames and their content part of the update procedure. Interesting thing is that the sort order is updated in the diagram view.
What you could try to do is to copy content of your query, delete it all, fill it with an empty tabel with one column, update power pivot and then go back to your query an paste your query back in.
If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun
Jimmy