Forum Discussion

powerbityro's avatar
powerbityro
Helper II
7 years ago
Solved

question composite model relationship

Hi All,

 

In connection with composite models it is said in literature that composite models only work for many-to-many relationsship:

 

The relationships with a many-many cardinality feature is part of the larger composite models capabilities in Power BI Desktop.

 

But i build up a composite model for many-to-one relationship and it works to. So did i missunderstand something? Why it works also for many-to-one relation?

 

many thanks!

  • hi, powerbityro 

    For many -many, This approach removes requirements for unique values in tables. It also removes previous workarounds, such as introducing new tables only to establish relationships.

    https://www.samanalytiks.com/blog_comment.php?blog=ODU=

    You could create the many-many relationship in it,

    and  you could also create the one-many or one-one relationship in it too.

     

    Best Regards,

    Lin

     

1 Reply

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support

    hi, powerbityro 

    For many -many, This approach removes requirements for unique values in tables. It also removes previous workarounds, such as introducing new tables only to establish relationships.

    https://www.samanalytiks.com/blog_comment.php?blog=ODU=

    You could create the many-many relationship in it,

    and  you could also create the one-many or one-one relationship in it too.

     

    Best Regards,

    Lin