Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
JamesHunttherea
New Member

Removing a Relationship

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.....

JamesHunttherea_0-1723040052452.png

 

 

Any help is appreciated!

 

James

1 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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

6 REPLIES 6
JamesHunttherea
New Member

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
Super User
Super User

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

rajendraongole1_0-1723042251634.png

 

Hope it works

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





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

MFelix
Super User
Super User

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".


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



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

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Top Solution Authors