Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
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
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).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |