NEW! FREE 45 Minutes Excel VBA Loop Course for Beginners Watch now 

Power BITutorials

Read How to Remove Duplicates Using Power Query

1 Mins read

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 :

Related posts
Power BITutorials

Opportunity Analysis Power BI Dashboard

1 Mins read
Information: A software company that has two sales channels: direct and partner. The sales manager created this dashboard to track opportunities and…
Power BITutorials

Procurement Analysis Power BI Dashboard

1 Mins read
Information: It analyzes a manufacturing company’s spending on vendors by category and location. we explore these areas: Who the top vendors are…
Power BITutorials

Retail Analysis Power BI Dashboard

1 Mins read
Information: It analyzes retail sales data of items sold across multiple stores and districts The metrics compare this year’s performance to last…