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

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
miguel1
Microsoft Employee
Microsoft Employee

Unable to delete table

I get the following message while trying to delete a table:

 

snip_20160229165629.png

 

When I click "Apply Changes" on the top notification bar, I get the following:

 

snip_20160229165812.png

 

The table is gone from the Queries, but it's still present in the data model. How can I get rid of it?

1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

4 REPLIES 4
Greg_Deckler
Community Champion
Community Champion

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?



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

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. 

Yes, that solved it. I had deactivated the relationships but deleting them worked. Thanks!

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

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors