Forum Discussion
SevsBo
Responsive Resident
Responsive ResidentPhantom ambiguous paths between tables causing issues
I think this is a bug in Power BI Desktop. We have the below data model, with single-direction relationships between the offending tables. If we create a table that links to Date Conversion a...
Consider this user error. We had two dates going to two different dates on the same table. The original model didn't have an issue as one of those relationships was many-to-many and the other a one-to-many, so the latter got prioritised and prevented the ambiguity error. Once we built identical types of relationships, the ambiguity came into effect.
SevsBoResponsive Resident
Responsive ResidentConsider this user error. We had two dates going to two different dates on the same table. The original model didn't have an issue as one of those relationships was many-to-many and the other a one-to-many, so the latter got prioritised and prevented the ambiguity error. Once we built identical types of relationships, the ambiguity came into effect.