Power Query cannot only keep duplicate records but also can remove the duplicate data. The advantage of this feature is that it removes the human error whenever you try to delete your duplicate data manually.
Remove Duplicates by Power Query
Suppose you have this set of data. As you can see the marked ones are duplicate values, why not get rid of them!
Step 1: Load the data in Power Query and note the duplicate data
As shown in the below picture, there are few duplicate row items that are highlighted.
Step 2: Remove Duplicate Rows
To remove the duplicate rows, go to
Home > Remove Rows button > Remove Duplicates option
Step 3: Save and Close
After you get the expected result, just click on the save icon to save and Close and Apply button to close the Query Editor.
You can learn more :