Forum Discussion
Unable to delete table
- 10 years ago
It sounds like you have some sort of relationship that references the table. Go into your relationships area and remove any relationships connected to that table. If you still get an error, do you have any DAX formulas that reference that table?
It sounds like you have some sort of relationship that references the table. Go into your relationships area and remove any relationships connected to that table. If you still get an error, do you have any DAX formulas that reference that table?
- miguel110 years agoMicrosoft Employee
Yes, that solved it. I had deactivated the relationships but deleting them worked. Thanks!
- Anonymous9 years agoNot applicable
Also, I found the same problem and after deleting the relationship in table arrangements area I still could not delete the old fact table. Based on ideas from above though I was able to delete that old table after deleting the error messages related to the old table; such error sets were in power query part of PowerBI Desktop. Guess any reference to old table needs to go away. Thanks for the ideas above.
- klaus_martinez9 years agoRegular Visitor
I am unable to see the relationships via the visual report (relationship manager) in Power BI desktop. The error that I get Points to four different queries "The query "table1" cannot be deleted because it's being referenced by other queries: "query1", "query2", "query3", "query4"." I am not able to see another forums about this.