Forum Discussion

Curious44's avatar
Curious44
New Member
8 years ago
Solved

Joining tables using calculated column

I am trying to join two tables T1 and T2.

 

T1 has a calculated column which is concatentation of fields Type and Age.

T2 comes from excel and had the fields Type and Age concatentation performed in excel prior to loading.

 

When I try to join, get error where it believes relationship is many to many.

Can pull individual fields into Power BI and join back to T1 w/o issues.

Also spot checked the data and do not see any issues with T2 i.e. concatenated field is unique.

 

Any assistance would be appreciated.

 

Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    Blanks and nulls can trip you up.  Every single value/row in the table on the 1 side of the 1:Many must be unique.   So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.

1 Reply

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    Blanks and nulls can trip you up.  Every single value/row in the table on the 1 side of the 1:Many must be unique.   So if you can have blank values in this column and there are more than 1 row with a blank column, you will fail this referential integrity test.