Forum Discussion
Power BI Relationship issues
Hi KitCat_PBI
From a glance, your model contains too many relationships with Many To Many, not good.
What I would recommend you is start building your model step by step depending on your business needs. So, I would start by deleting all the relationships, open a new Tab and bring only the tables that you need for your KPIs or visuals, create a 1 too many relationship and if dosen't work then look for the Table that could make the bridge.
Hi aj1973,
I have tried rebuilding this model a few times and tried to reduce the many to many relationships, however due to the nature of the business and the data tables this has not really been possible to reduce. The only tables in the model are the ones that are being used for the visuals.
I have tried to create a bridging table between the dates and the directory but no matter what I try I have no success. Is there anything else I can try?
Thanks
KitCat85
Hi KitCat_PBI
Honestly it is very hard to tell you what to do just by looking at some pictures. Maybe a mock pbix can help me understand your problem