Table of Contents
Removing duplicates in Power BI is a process of identifying and removing duplicate rows from a dataset in order to improve data accuracy and analysis. This can be achieved by using built-in functions and tools such as the “Remove Duplicates” feature, which allows users to select specific columns and remove identical rows. Additionally, Power BI also offers advanced options such as merging queries and using custom scripts to further eliminate duplicates. By removing duplicates, users can ensure that their data is more reliable and can make more informed decisions based on accurate information.
Remove Duplicates in Power BI (With Example)
The easiest way to remove duplicate rows in a table in Power BI is to use the Remove Duplicates feature within the Power Query Editor.
The following example shows how to use this feature in practice.
Example: How to Remove Duplicates in Power BI
Suppose we have the following table in Power BI that contains information about various basketball players:
Notice that there are several rows that contain the same value for the Team and Position columns.
Suppose that we would like to remove the rows that have duplicate values across these two columns.
To do so, click the Home tab along the top ribbon, then click the Transform data icon:
This will bring up the Power Query Editor:
While holding Ctrl, click the columns named Team and Position. Then right click and click the option called Remove Duplicates:
This will remove rows that have duplicate values across both the Team and Position columns:
When you exit out of the Power Query Editor, it will ask if you’d like to apply the changes you made to the original table.
Click Yes to apply the changes.
Additional Resources
The following tutorials explain how to perform other common tasks in Power BI: