Relationship Not Saving

[powerbiuserasu]

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 is happening and what I can do to fix it. It allows me to save the relationships but it just disapears afterwards. 

[Drakef]

I am also having this issue, just installed this last week.

I click save one a relationship that should work I get no erro message or anything and acts like it saves but never does.

[bruchiel]

I am having the same problem - Version: 2.140.1078.0 64-bit (February 2025)

Any updates on when this will be fixed?

[lbendlin]

try Version 2.140.1476.0 

[Sean_Earp]

I am also hitting the same issue on Version: 2.140.1351.0 64-bit (February 2025)

I add a relationship, save the .pbix, close it, re-open it, and the relationship is gone.  Are there any workarounds until it gets fixed in Power BI Desktop?

[lbendlin]

Try this version that was published 25 years ago!

(Note:  it's actually 1351.  Their web page is out of sync again)

[anna_pbi]

I'm having the same issue. Anyone found a fix? 

[murphyse]

Same problem. I'm just trying to save a 1:Many relationship and when I click save, it thinks, then does not save the change in the Model View.

[lbendlin]

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[leafrancis95]

Hi,

I'm experiencing the same issue for the first time. I've tested various relationships, including those automatically detected by Power BI, but every time I save and return to Manage Relationships, the new relationship disappears. Any assistance would be greatly appreciated!

I'm using Version: 2.140.1205.0 64-bit (February 2025)

[leafrancis95]

I tried again this morning, and the bug seems to have been fixed ! Relationships properly saves. 

[Kmschi]

I'm having the same issues with saving modeling or re-activating modeling that worked prior to the Feb 2025 update.  It doesn't give you any error message and acts as if it is saving the relationship, but then doesn't save it.  My collegue had the previous version of BI desktop and ran the same modeling relationship in the old version and it saved.  

[albelanger]

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]

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]

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]

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

[Anonymous]

Hi @powerbiuserasu,

Thank you for reaching out to Microsoft Fabric Community Forum.

I don’t see any issues on my end.
version i am using Version: 2.140.829.0 64-bit (February 2025)

Please check if the key columns in both tables have the same data type, as mismatched types can prevent Power BI from saving the relationship.

Also, if an indirect relationship already exists through another table, Power BI may not allow a direct one.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!

Regards,
Vinay Pabbu

[powerbiuserasu]

They seem to be the same data type and I am not getting a message that there is an ambiguous relationship. I am using Power BI desktop version 2.140.1205.0

[Anonymous]

Hi @powerbiuserasu,

As suggested by @lbendlin, can you please raise a support ticket? If you have already done so, please share the update and solution here. This will help other community members facing similar issues resolve it faster.

How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Regards,

Vinay Pabbu

[Anonymous]

Hi @powerbiuserasu,

There is confirmation from @leafrancis95 that the bug has been fixed. Could you please check and confirm from your side that the issue is resolved?

Regards,

Vinay Pabbu

[Anonymous]

Hi @powerbiuserasu,

As we haven't heard back from you, I hope you have raised a support ticket. At this time we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we are here to assist you. Thankyou for your understanding and continuous support.

Thank you for being part of the Microsoft Fabric Community.

Regards,

Vinay Pabbu