Relationship Many to Many on Report Server

[Anonymous]

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 columns must have unique values".

 It is possible solve this problem?

Regards,

Marco

[Petebro]

Wanted to bump this old thread because it is high on search engine results to announce that many to many relationships will be supported in Power BI Report Server (and Power BI Desktop for RS) in January 2024 versions and later.

[d_gosbell]

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]