Forum Discussion
Shamatix
Post Partisan
Post PartisanMany to Many Relationship
Hey fellow users of Power Bi, First of all I wouldnt be here if I hadnt searched and tried figuring this out by my self at first, but sadly without any luck. My situation will be a bit hard to e...
Found a solution, problem was bugs regarding duplicates in power bi
vanessafvg
Community Champion
Community ChampionThere is also one other thing you can do to isolate the problem
in your visual layer on both sides of the relationships
place 2 tables on the visual desktop canvas
and drag the key field from either side of the tables into their own table - drag the key field in again and change it to a count, so that it aggregates on the key field.
and then sort by the count field, in descending order you should see the cullprits on the top.
let me know if you need a visual
ShamatixPost Partisan
Post PartisanSorry, I am quite new to power bi in general and would love to see it visually if possible or perhaps a skype session tomorrow? As said I really do not mind paying in order to get all my relationships working=/