You could do this by opening the Power Query editor, selecting all columns, and then right click and press "remove duplicates".
This will remove all duplicate rows based on the columns you selected.
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!