Forum Discussion
Table View Columns not in Alphabetical Order
I have used the M script in the Advance Editor to organise the 100 columns in alphabetical order, and it works. However, in Table View, the columns are not in alphabetical order. Is there any...
There's no real reason for table view to be shown in alphabetical order (because the sort-order can be changed dynamically in the reports).
If there is some reason that you need to see your data in alphabetical order, you can click on the down arrow next to the column header, and sort A-Z that way. (Note - if this is the case, then you also don't need to include the step in PowerQuery to sort alphabetically, because the results aren't guranteed when you load the data in)
See this post for more details: https://community.fabric.microsoft.com/t5/Desktop/To-have-data-sorted-the-same-in-Data-view-as-it-s-in-Editor/td-p/2039315