topic Re: Fabric automatically create some relationships that I can't delete in Data Warehouse

Fabric automatically create some relationships that I can't delete

MylenePBI — Mon, 20 Nov 2023 10:22:00 GMT

Hello, I have a new problem with Fabric: when I create a single direction relationship between a dimension table and a facts table and a dimension table, it automatically creates a second relationship, in the other direction. When I delete this second relationship, it automatically recreates it. The result is that I have relations that I don't want, that are wrong in my model, and I am stuck to create some relationships that I need. Seems like it is a known issue. Is there a known workaround? Anonymous

Re: Fabric automatically create some relationships that I can't delete

AndyDDC — Mon, 20 Nov 2023 10:47:14 GMT

MylenePBI that sounds like a bug and I have had this issue as well. Anonymous can raise it again with the support team.

Re: Fabric automatically create some relationships that I can't delete

Anonymous — Mon, 20 Nov 2023 11:05:52 GMT

Hi AndyDDC MylenePBI
Thanks for reporting this. I will forward the same to the internal team to get some help on this.
I will update you once I hear back from them.
Thanks.

Re: Fabric automatically create some relationships that I can't delete

Anonymous — Thu, 23 Nov 2023 17:52:41 GMT

Hi MylenePBI
Apologies for the delay in response.
The internal team has confirmed that the error is related to duplicate relationship on modelling page. I have created a bug and forwarded this to the internal team.
There is an ongoing fix on this issue. We do not have any ETA regarding the fix.
I will keep you posted regarding the updates.
Appreciate your patience.

There is no workaround for this issue.
Please let me know if you have any further questions.

Re: Fabric automatically create some relationships that I can't delete

Anonymous — Mon, 27 Nov 2023 07:56:13 GMT

Hi MylenePBI
We haven’t heard from you on the last response and was just checking back to see if you got some insights regarding the issue.
Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Fabric automatically create some relationships that I can't delete

Anonymous — Tue, 28 Nov 2023 14:56:38 GMT

Hi @MylenePBI
Following up to check if you got some insights regarding the issue.
Otherwise, will respond back with the more details and we will try to help.
Thanks

Re: Fabric automatically create some relationships that I can't delete

Oscar8a — Tue, 05 Dec 2023 21:51:27 GMT

Hi Anonymous

I'm getting the same issue with my model, is there any way to fix this?

Thanks

Re: Fabric automatically create some relationships that I can't delete

Anonymous — Thu, 07 Dec 2023 11:12:44 GMT

Hi Oscar8a
Apologies for the issue you have been facing. This is due to a bug. There is no workaround for this issue.
There is an ongoing fix on this issue. We do not have any ETA regarding the fix.
I will keep you posted regarding the updates.
Appreciate your patience.

Re: Fabric automatically create some relationships that I can't delete

arpost — Tue, 26 Mar 2024 20:45:26 GMT

Any update on this? I'm experiencing what seems to be a similar issue in terms of the warehouse not letting me delete relationships. I keep getting an error that states "Object reference not set to an instance of an object."