Cannot delete “ghost” table from Power Pivot

0
votes

I have created many power queries and power pivot tables in my Excel file. After some time, I think the data structure may have gotten corrupted, because this is happening:

In Data Model, I have this Community_Membership table that cannot be deleted. It is the only table that has this behavior (all other tables were deleted successfully)

enter image description here

After that, I went to Power Query to delete all existing queries AND CONNECTIONS, so that the list is empty like below. enter image description here

enter image description here

enter image description here

But this table remains un-deletable there after I have deleted all queries from queries list.

Anybody know how to fix this?

1
powerbipowerpivotpowerquerydatamodel

1 Answers

0
votes

I finally recreated the file as follows:

  • Make a new Excel file
  • Copy all of the sheets
  • Select all of the queries from the old file's query pane, hit copy
  • Go to the new file's queries pane, hit paste
  • Go into Query Editor and edit any names with conflicts or remove any redundant queries

The entire process takes about 10 minutes as I only had about 10 queries / sheets.

I suspect this happened because I created a query, added it to the data model then went back to Power Query and edit it (either its name or its content in some mysterious way). After that the link between PQ and PP is broken so that even after the original query is deleted, its clone in PP remains. Strange.