Removing a Relationship

[JamesHunttherea]

Hello

We have datasets linked through a semantic model. The semantic model is linked through an SQL to our underlying software. I have created a relation between two tables. I am unable to delete the relationship, as it is greyed out, but I created it!

Very confused.....

Any help is appreciated!

James

[JamesHunttherea]

Hello

In that case I do not know what the error is, I did add the relationship on the desktop, it isn't part of the original semantic model but now it seems to be!!

James

[rajendraongole1]

Hi @JamesHunttherea - you can select the checkbox so that we can do modification on the top of the relationships

Blue color box check that and modify the relationship

Hope it works

[JamesHunttherea]

Thank you! I should have said in my post what I had tried already. I attempted to click the box, still no joy.

[MFelix]

Hi @JamesHunttherea ,

Are the relationship  coming from the semantic model or the SQL server ?

If the relationship is from the semantic model to delete it you need to go to that semantic model delete it, you cannot edit the semantic model "locally".

[JamesHunttherea]

Hello Miguel

Thank you, I suspect this will be the answer. I did not know I could not change locally. Useful to know you can add but not delete.

James

[MFelix · Accepted solution]

Hi @JamesHunttherea ,

Depends where you have created the relationship, because if the relationship was created on the desktop you should be able to remove it, if it's coming from the original semantic model them you have to do it online.