Hello,
I am trying to merge two datasets but I am getting duplicates or datapoints getting bloated. I tried removing duplicates but my numbers in the merged table is different from the other two.
Hi @elmarthg ,
1. Is it possible to add more column pairs besides the [regardingobjectid] column?
Solved: merging causes duplicates
2. Does the null in the [regardingobjectid] column make sense? If not, you can filter it and merge the query.
3. Please try the step like this.
= Table.TransformColumns(#"Merged Queries",{"Table2",each Table.Distinct(_)})
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Hi @elmarthg ,
1. Is it possible to add more column pairs besides the [regardingobjectid] column?
Solved: merging causes duplicates
2. Does the null in the [regardingobjectid] column make sense? If not, you can filter it and merge the query.
3. Please try the step like this.
= Table.TransformColumns(#"Merged Queries",{"Table2",each Table.Distinct(_)})
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
