how to create relationship product master DB master calendar master to primary & secondary table

[shri0025]

I'm trying to connect a calendar to a database that already has an active Many to Many relationship with another catalog, but when I try to do so, an error of ambiguity appears. The most anoying part is that, those same relationships, are active in another database. Bellow I give an example of this problem:

This is the error message that pops up.

Please help how to create relation 

[v-rzhou-msft · Accepted solution]

Hi @shri0025 

I couldn't find the error message in your post.

I think when you only active four relationships like your screenshot, your data model will work well.

If you active other inactive relationships may cause the Relationship Loop in your data model. This may cause the error or wrong result. I think you should avoid the relationship between tables to become a closed loop.

In Power BI, Snow Scheme and Star Scheme are the most used. I find some offical blogs for data model in Power BI.

For reference: Understand star schema and the importance for Power BI

For more details about how to build relationships in Power BI, you may refer to this blog:

Create and manage relationships in Power BI Desktop

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Can you articulate the reason for the M:M relationship?  Is it possible to avoid that and use a star schema instead? Star schemas also work with multi fact data models, when each dimension table is controlling all fact tables.