Forum Discussion

Uli_from_German's avatar
Uli_from_German
New Member
9 years ago

Relationships and modelling data

I have a problem with modelling Data-tables : Table One :   Buildings (Definition of houses)                        Column :  Building_ID  120                                        Building_ID  1...
alexanderg's avatar
alexanderg
Advocate II
9 years ago

Hi Uli_from_German

 

In Power BI the relationships between two tables must use only one field. If you want to create a relationship based on two or more fields, that is a compound key; For this you have to create a new column concatenating the key fields. You must do the same process in the other table.. and then you can establish the relationship.

 

Regards,