Forum Discussion
Relationship Many to Many on Report Server
Hello, I'm trying to do a Many to Many Relationship on Power BI Report Server (May 2021), but this error occurs "You can't create a relationship between these two columns because one of the colu...
I don't believe Report Server supports many to many relationships. The work around is to create a bridge table with a list of the distinct values from one of your columns (you can do this with a calculated table using an expression like VALUES( table[column] ).
Then you create a many to 1 and 1 to many relationship chain like the following to achieve the same behaviour as a m2m relationship:
table1[column] * --> 1 calcTable[column] 1 <---- * table2[column]