Forum Discussion
Remove duplicates from a report
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
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
2 Replies
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).
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
