Forum Discussion
miguel1
10 years agoMicrosoft Employee
Unable to delete table
I get the following message while trying to delete a table: When I click "Apply Changes" on the top notification bar, I get the following: The table is gone from the Queries...
- 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?
miguel1
10 years agoMicrosoft Employee
Yes, that solved it. I had deactivated the relationships but deleting them worked. Thanks!
Anonymous
9 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.