Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 4 tables for our in-house project tracking app. We track info at different levels of detail between our estimate and planned, which I think is causing the issue, but not sure.
TABLES - there is more, non-pertiennt info in each table
In Power BI Desktop
Estimate is related to Percent Complete via TaskID
Period is related to Percent Complet via PeriodID
Period is related to Planned via PeriodID
Estimate is related to Planned via a concatenated field of ProjectID + Team + Discipline via an intermediary b/c on their own it is a many to many relationship
The problem occurs when I try to connect Period to Planned via PeriodID and it says I am introducing ambiguity, I am assuming through the Estimate to Percent Complete to Period relationship
I'm sure you'll need additional info, please let me know what else I can provide to get past this one...thanks!
Solved! Go to Solution.
A good first tip is to make sure you don't have any Bi-directional relationships unless you know you need them for sure.
So make sure this setting is set to Single and not Both on all your links.
You can tell which ones are set to both by looking at the arrows on the link (2 vs 1 direction). Try that and report back 🙂
h
A good first tip is to make sure you don't have any Bi-directional relationships unless you know you need them for sure.
So make sure this setting is set to Single and not Both on all your links.
You can tell which ones are set to both by looking at the arrows on the link (2 vs 1 direction). Try that and report back 🙂
h
Thanks, trying now and will report back
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |