Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
107 | |
89 | |
81 | |
76 | |
73 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |