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

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register 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.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors