The "Remove Duplicates" command retains only the first occurrence ... as it is a fundamental SQL function. Power Query ...