Forum Discussion
Best practice advice data model
Hi Anonymous
I think the one-to-many bidirectional relationship will be better than a many-to-many relationship between table B and D (on ID). Sometimes we cannot avoid bidirectional relationships completely. As the current bidirectional relationship is one-to-many, its filtering result is still accurate.
Best Regards,
Jing
Hi Anonymous
I think the current relationships are good for this small part model. The data model is not the only factor that influences the report performance. You can also consider optimizing other aspects like removing unnecessary data, removing unnecessary interactions, reduce the number of visuals on a page, avoiding too many complex DAX expressions, .etc.
The following articles provide some suggestions on how to improve the performance. You may find them helpful.
Best practice rules to improve your model's performance | Microsoft Power BI Blog
Tips to increase the performance of your Power BI Reports | by Elias Nordlinder
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!
Hi Jing,
Thanks a lot for your response. I will have a look at the links you provided.
So you do not think the bidirectional relationship between B and C is a problem? Or do you know a way to get rid of it? Indeed this is only a small part of the model but I have about 8 or 9 of these similar setups with other tables & slicers.
Thank you!
Martine
Hi Anonymous
I think the one-to-many bidirectional relationship will be better than a many-to-many relationship between table B and D (on ID). Sometimes we cannot avoid bidirectional relationships completely. As the current bidirectional relationship is one-to-many, its filtering result is still accurate.
Best Regards,
Jing