Forum Discussion
Table Relationship Issues
Hi v-juanli-msft ,
Thank you for your response. I realized that I did not have a serial number listed more than once in my sample Sales Transaction data once I had left for the day and have now corrected. Thank you for realizing that.
All the training and dicussions I have had with others have advised to stay away using many to many relationships, which is why I did not use it. Are there any negatives that you have experienced with using Many to Many?
Thank you
Hi szub
Your screenshot shows a workaround for many to many relationships for two tables in power bi.
Please see differences between two methods:
Use relationships with a many-many cardinality
One big disadvantage is many to many relationship may slow the performance for the report.
For specific scenario, please use Performance Analyzer to examine report element performance and decide which method to use.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.