Forum Discussion

AlmDon's avatar
AlmDon
Regular Visitor
8 years ago
Solved

Combining two seperate excel sheets that have the same primary key in both

Hi,   I am new to Power BI and I am trying to add two different ecel sheets that have the same primary key in both. I am trying to be able to create a relationship between these two sheets so i can...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    So, what you want to do is to create a 3rd query. This query will append your other two queries and then get rid of all of the other columns other than the PK. Then, remove duplicates on the PK and import. Relate this table to your other two tables and use the PK column in this table in your visuals (I would personally hide the other PK columns in the fact tables to prevent confusion).

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

So, what you want to do is to create a 3rd query. This query will append your other two queries and then get rid of all of the other columns other than the PK. Then, remove duplicates on the PK and import. Relate this table to your other two tables and use the PK column in this table in your visuals (I would personally hide the other PK columns in the fact tables to prevent confusion).