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.
Hi
I have a number of different data tables [DT1:DT7] which have a relationship to a single employee table [Emp} so that I can pick an employee from [Emp} and it will filter all seven tables - this is working fine
I now have an 8th data table that I also want to create a relationship to [Emp] but it is saying I cannot as would introduce ambiguity between Emp & DT3
I can't see why this works on the other DTs but not DT8
This explains the relationships that are already working:
DT1 Employee_SID Relates to Emp EmpID
DT2 UserID Relates to Emp EmpID
DT3 Employee_SID Relates to Emp EmpID
DT4 OwnerID Relates to Emp EmpID
DT5 Emp_ID Relates to Emp EmpID
DT6 Owned_BYID Relates to Emp EmpID
DT7 ChngdByID Relates to Emp EmpID
And the one that is now causing the issue
DT8 CreatedBYID Relates to Emp EmpID
Thanks in advance for any advice
Solved! Go to Solution.
@PBI_Inquisitor , This may be because of bi-direction joins
Make all One -Many join as single direction
@PBI_Inquisitor , This may be because of bi-direction joins
Make all One -Many join as single direction
Thanks Amitchandak - seems to have done the trick - swapped around each relationship as well eg Emp - DT1; Emp to DT2.
Kind regards, Phil
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 |
---|---|
47 | |
24 | |
20 | |
15 | |
13 |
User | Count |
---|---|
55 | |
48 | |
43 | |
19 | |
19 |