Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Merge queries (Duplication)

Hello,
I have a problem while merging the queries, all my data is getting duplicated. I have 2 tables, I want to join- table1.MN left outer join table2.MN.
However all my values are getting duplicating decause of unique values. Is there any way to join these 2 tables.

 

Need Help

4 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    5 years ago

    Hi Anonymous 

    Separate the 2 tables into 2 sheets then import you excel file to Power Bi. Normally Power bi engine will join them at MN Column

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi aj1973 

      I did all of those, I ended up with 1800 duplicated rows which is double the data. The data i have shown is a dummy one which represents original one. I want my data merged without any duplicates.

      • aj1973's avatar
        aj1973
        Community Champion
        5 years ago

        If you have 2 tables (it looks like one is Fact and the other Dimension) whay would you want to merge them? in your model you can just join them at MN column and build your report.

        Can you screenshot your model please?