Forum Discussion
Cannot edit relationship
Hello,
I have a relationship between two tables and relationship is currently inactive, many to one and cross-filter direction set as both. Both tables storage mode is import. The problem is that I cannot do any changes to that relationship or delete it. What makes this strange is that I get no errors, changes just don't apply. I've tried properties window, manage relationship window and straight delete from model view. I get that "Working on it" notification but nothing happens. Are there any ways to solve what prevents editing / deleting? Thanks!
15 Replies
Hi Testeri It might be because of the PBI file i guess....could you try restartingPower Bi and these
- Refresh the model to update metadata.
- Delete the relationship in Model View and save the file.
- Export tables, re-import them, and recreate the relationship.
Hi, thanks but these didn't help. Cannot delete the relationship and cannot even delete the table.
Hi, thanks but this didn't work. No error but the relationship doesn't disappear.
You can download Tabular Editor from SQLBI and maybe that will let you edit the file.
https://www.sqlbi.com/tools/tabular-editor/
You would open your .pbix
Open Tabular Editor, click open a model from existing database and pick your .pbix file.
Then expand the relationship folder, delete the relationship and save the file in Tabular editor.
Thanks but I cannot delete relationships in Tabular Editor neither.
Is the data source for your .pbix file the data model from another .pbix file that was published to the service maybe? If so, you would have to delete the relationship in that model, yours is just pointing at it but cannot change it.
Data model is created in the current pbix file.
Hi Testeri ,
Thanks for reaching out to the Microsoft fabric community forum.The PBIX file may have become corrupted, try clearing the cache and restarting Power BI Desktop. Save your work first, then navigate to File -> Options and settings -> Options -> Data Load -> Clear Cache. After clearing the cache, restart Power BI Desktop and attempt the operation again.
If the issue still persists after clearing the cache and restarting, you may need to create a new PBIX file, re-import the same tables, and rebuild the report within the new file to resolve any underlying corruption.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank youHi, rebuilding report is not an option because there are so many reports and data model is large and complex. Thanks anyway.
Hi Testeri
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
Hi, this is not resolved yet.
Hi Testeri ,
We really appreciate your efforts and for letting us know the update on the issue.
As a final troubleshooting step, Uninstall and re install the latest version of Power BI and then check if you are able to delete the relationship for this model.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS. Feel free to reach out if you need further assistance.
Thank you
Hi Testeri , you can try TMDL view in Power BI desktop and try to edit that relationship
please let me know did this solve your problem
I had this problem today. Trying to delete a 1 to many relationship, it would briefly think about it, and then nothing, relationship persists. Through trial and error, by attempting to delete several relationships at once through the Manage Relationships dialog, I was able to learn that a Circular Dependency between two calculated columns within the table on the one side of the relationship I wanted to remove was preventing its deletion. I removed the calculated columns and boom! I could then delete the relationship.
