Power Query column sort not propogating to the tables

Dear All

With due respect to message 3, I attempted to do this and did not get the desired result... perhaps I did not carry out the process correctly. Nevertheless, unloading, re-loading and re-establishing relationships is not ideal.

I did however manage to achieve the result (sorting by more than one column in data view) by creating the required sort order in Power Query then adding an index to the correctly sorted data and then, as the data is sorted differently when loaded to the data view, sorting by index in the data view.

Hope this helps, thank you.