CODEWITHSUNDEEP
ssasdaxssas-tabular
mohamed mohamed
mohamed mohamed

Reputation: 11

ssas tabular 2016 Many to many relationship

errori'm new here ,and in the ssas tabular modeling, im working on a project and i have to do a many to many relationship in ssas tabular 2016 BUT they give me this probleme.

my model is like this where index is note a primary key in both tables and i want to join the two tables with it.

thank you all ! model2

Upvotes: 1

Views: 1285

Answers (1)

Jon
Jon

Reputation: 4957

SSAS 2016 & 2017 does not support the Many-To-Many Relationship nativity in SSAS, you will have to use a bridge table. One other option which may meet your requirements is to activate the Bi-Directional filter in a Many-To-One relationship. A good outline is blogged about here.

Only SSAS 2019/Azure Analysis Services (Compatibility level 1500) & Power BI allows the native selection of Many-To-Many relationships.

Upvotes: 2

Related Questions