Solved: Remove duplicates from a report

Nikhi · ‎01-05-2021

Hi,

I am using table from my Visuals in Power BI and connecting 3 tables. After it joins I get duplicates. How do I remove it at the report level.

Regards,

Nikhi

Anonymous · ‎01-07-2021

HI @Nikhi,

What type of duplicate did you mean? The fully duplicate rows exited in merge tables? If this is a case, you can use the table remove duplicate function to remove them.

Remove duplicates (Power Query)
If you mean some fields exist duplicate values, it works as expected when you are trying to link two tables based on relationship keys between header and detail records. For this scenario, remove duplicate field values operation will also remove some detailed information rows.

Regards,

Xiaoxin Sheng

View solution in original post

Anonymous · ‎01-07-2021

HI @Nikhi,

What type of duplicate did you mean? The fully duplicate rows exited in merge tables? If this is a case, you can use the table remove duplicate function to remove them.

Remove duplicates (Power Query)
If you mean some fields exist duplicate values, it works as expected when you are trying to link two tables based on relationship keys between header and detail records. For this scenario, remove duplicate field values operation will also remove some detailed information rows.

Regards,

Xiaoxin Sheng

lbendlin · ‎01-05-2021

Power BI will never show duplicates (which is sometimes infuriating). What you likely see is a table product - do you have Many-Many relationships with bidirectional filters between some of your tables? (Hint: You don't want these).