Forum Discussion

Nikhi's avatar
Nikhi
Frequent Visitor
5 years ago
Solved

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
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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