
Wondered where the IsSorted Property was!
Select the source, hit F4 then click on Show Advanced Editor. Here you will find the IsSorted, which by default is False and which needs to be changed to True.


And then select the column to be sorted and set the sort order property.