Forum Discussion

juansgutierrezu's avatar
juansgutierrezu
Helper I
8 years ago
Solved

Ambiguous paths among tables! :(

Dear Power BI community: I've been wondering how to solve this issue, but I don't seem to be able to figure it out, that is why I am writting to you.   I have the following relationships among my t...
Need Help
  • juansgutierrezu's avatar
    juansgutierrezu
    8 years ago

    Thanks for answering jthomson. I've already solved it by deleting the relationship between Fact_people_education and Dim_household_data. As far as I have read, Power BI doesn't stand complex and several relationships among tables since it doesn't which look up table give priority to use in order to filter fact tables. I guess I still need to read more about relationships.

     

    Regards.

jthomson's avatar
jthomson
Solution Sage
8 years ago

Well, it could go through fact_employment or it could skip it, that's probably the issue

juansgutierrezu's avatar
juansgutierrezu
Helper I
8 years ago

Thanks for answering jthomson. I've already solved it by deleting the relationship between Fact_people_education and Dim_household_data. As far as I have read, Power BI doesn't stand complex and several relationships among tables since it doesn't which look up table give priority to use in order to filter fact tables. I guess I still need to read more about relationships.

 

Regards.