Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Ambiguous paths between tables connection

I have : 2 master table dim: Master_Area and Master_Date 3 fact table : FACT_TABLE_A, FACT_TABLE_B, FACT_TABLE_C   When I connect Master_Area 1: many to FACT_TABLE_A, FACT_TABLE_B, FACT_TAB...
Need Help
  • v-henryk-mstf's avatar
    v-henryk-mstf
    5 years ago

    Hi Anonymous ,

     

    I think the main reason is that the wrong activity relationship is set up. Generally speaking, there can only be one active relationship between two tables. If there is more than one relationship, it needs to be set as an inactive relationship. In addition, specific screening directions may also cause errors. Therefore, you can refer to the specific official documents to view the relationship model between the constructed dimension table and the fact table.

     

    reference document link: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Docs


    Best Regards,
    Henry

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

HotChilli's avatar
HotChilli
Community Champion
5 years ago

It's not possible to give you a full answer because the diagram doesn't show the direction of the relationships (i.e. how they filter)  but basically powerbi prevents alternative paths between tables.  There must be (at most) only one path between any two tables.