March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
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
Solved! Go to 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello
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
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
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.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHello 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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
123 | |
85 | |
85 | |
70 | |
51 |
User | Count |
---|---|
205 | |
157 | |
97 | |
79 | |
69 |