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 a table that is not allowing me to create a 1:* relationship when it should.
I've tried to remove duplicate, null, and blank values, and I've exported to Excel to try and highlight duplicate values, but it's still not letting me set the relationship.
It's automatically creating a many to many relationship when it should be 1:*
I get this error. *The cardinality you selected in't valid for this relationship
any ideas?
Solved! Go to Solution.
@Anonymous - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:
@Anonymous - That error indicates that the key column of the dimension (one-side) has duplicates or blanks. To troubleshoot:
I've fixed it... I'm not exactly sure how, but I re-did the qurey and merge.
On my original join I set the criteria to filter the last report date and join w/ the other source data.
On the new one, I first copied my table then filtered to include only the Latest report, then merged on that. That worked.
Thanks.
yes, I've gone through those steps and it's still registering the column as a Many column... I have this same issue in another model that I'm working on and I'm stuck as to what to do to resolve it.
Happy to help with your dataset...
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |