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
I basically duped my entire query back, as what I did in the past. Needless to say, it is hurtful to do the remodelling etc, but better now than later. Thanks tho.
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