Data View column order change

oh my - - did see old Q&A on this topic - - just thought I would check.....

I will hazard the guess that Data View isn't perceived as important in that all the action is up in Visuals....but this lack of column rearrangement sure makes the initial modeling/transform more difficult to the BI designer first discovering the data set that we're working with......

I just found out a work-around that is possible since the introduction of the Power BI Project (TMDL) format:

1. Make sure the report is saved as .PBIP format.

2. Make sure the report is closed in Power BI Desktop.

3. Look for the <tabelname>.tmdl file in the project folder you want to change and make the changes via any text editor by moving the corresponding column definition text portion. Make sure the indentation is not effected, since it may corrupt the report.

4. Delete the cache file "cache.abf". 
5. Reopen the report in Power BI Desktop. And check the results.

Hope this helps. Cheers. 

And this is April 2021 still unsolved...I really don't think the feedback system in Power Bi works!

This is really annoying. I changed my headers to try to force Power Bi to display my fields in the same order as in the source file iand all it accomplished was to keep related columns together. But Q45 is at the top and... you get the idea. Total chaos. This adds a lot of unnecessary work to the simple task of assembling visuals from a table with a lot of columns and it seems to be something that could be fixed by just not changing the order of columns from the source (or at least making it an option)!