Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
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.
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]
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
11 | |
11 | |
4 | |
1 | |
1 |
User | Count |
---|---|
19 | |
17 | |
3 | |
2 | |
2 |