Forum Discussion

vincentjdc's avatar
vincentjdc
Frequent Visitor
4 years ago

Multiples JOINS same table

Hi,   I manage multiples tools and multiples databases in my company. My CFO want to use Power BI to make reports based on the databases.   we are facing a problem with relationships. Multiples ...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi vincentjdc ,

A model is ambiguous when there are multiple paths between tables. In an ambiguous model, the engine has multiple options when transferring a filter from one table to another. Therefore, it either finds a preferred way to transfer the filter, or it raises an error.

Look at the model and check where the ambiguity is. You need to find two tables that are linked through different paths, following the arrows of the cross-filter.

Additionally, star schema is often recommended in Power BI modeling.

 

Related document for your reference: Understand star schema and the importance for Power BI - Power BI| Microsoft 

Bidirectional relationships and ambiguity in DAX - SQLBI.

 

Best Regards,
Community Support Team _ kalyj

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