Forum Discussion
Relationship Not Saving
I have tried to create a new relationship between two tables but after I save the relationship when I go back into the manage relationships pane the relationship is not there. I am not sure why this ...
That may be a different issue/cause. When it refuses to accept a 1:* relationship then you have either duplicates or blanks at the 1 side.
Hello Ibendlin,
I agree with you however I have removed the duplicates, removed blanks/nulls as well as doing a trim on the 1 side:
So I'm not sure what's causing this and I'm not getting any error message, it's simply doesn't do anything.
You were right, it seems relationships in PowerBI are case insensitive while doing a duplicates cleanup is case sensitive. Lesson learned, thanks again.