topic Remove duplicates from a report in Developer

Remove duplicates from a report

Nikhi — Tue, 05 Jan 2021 23:56:14 GMT

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

Re: Remove duplicates from a report

lbendlin — Wed, 06 Jan 2021 02:17:23 GMT

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).

Re: Remove duplicates from a report

Anonymous — Fri, 08 Jan 2021 01:15:55 GMT

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