This has to be so basic, yet I can’t understand why my sort order in PQ is not adhered to when I change the sort order in my source.
Attached is a sample file.
In PQ - sort order is Exchange then Ticker.
But when I change the sort order in the source, the result isn’t updated.
I can add or change records, no problem, but can’t the sort order to work.
This must be one of the most basic things… I’m sort of embarrassed to post this.
PowerQuerySortNotWorking.xlsx (19.7 KB)