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'm not able to create a 1 to many relationship on a text field. I keep running into this problem and am not sure what I'm doing wrong.
I've done the following:
In power query - trimmed, removed null values, made sure everything is in upper case
Dax - concatenated fields to create a unique value
I made sure I'm trying to create the relationship on the correct column - searched for null or blank values in both tables again, and came up with nothing.
Both columns are Text type.
I exported my unique table and tried to highlight duplicates, and there are none - yet Power BI won't let me create the 1:* relationship.
What could the issue be?
Timely filing table contains a unique list of 'Entity-Provider'
Aging Detail has many -
Thank you!
Solved! Go to Solution.
well.... I went back into power query and on my dimension table, removed duplicates (even though there were none). Now it's letting me create the relationship.
well.... I went back into power query and on my dimension table, removed duplicates (even though there were none). Now it's letting me create the relationship.
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 |
---|---|
107 | |
105 | |
79 | |
69 | |
62 |
User | Count |
---|---|
142 | |
105 | |
103 | |
85 | |
70 |