Forum Discussion

powerbiuserasu's avatar
powerbiuserasu
Advocate I
1 year ago

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 ...
Need Help
albelanger's avatar
albelanger
Regular Visitor
1 year ago

Hello,

 

I'm facing the same issue using version: 2.140.1205.0 64-bit (February, 2025)

 

When I'm trying to create a new relationship that autodetects to "many-to-many" and try to override it to one-to-many (which is what it should detect...), it won't save. I tried deleting it and recreating it by setting it directly to "one-to-many" and it won't save.

lbendlin's avatar
lbendlin
Super User
1 year ago

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.

  • albelanger's avatar
    albelanger
    Regular Visitor
    1 year ago

    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.

    • albelanger's avatar
      albelanger
      Regular Visitor
      1 year ago

      You were right, it seems relationships in PowerBI are case insensitive while doing a duplicates cleanup is case sensitive. Lesson learned, thanks again.