I am working on a Power Pivot model in Excel that uses a dataset of 10 million rows. In the Power Pivot data model, I see two tables: Table (the main table I am using) and Table1. However, Table1 is idle and not needed. When I try to delete Table1 from Power Pivot, it gives an error stating that this table is built in Power Query and must be removed from there. The problem is that in Power Query, I only have one query related to this dataset, which corresponds to Table, and there is no separate query for Table1.
I have verified that the "Load to" settings in Power Query are set correctly for the main table. I also checked the worksheet and do not see any duplicate named table (Table1) linked to the data model. Despite this, Table1 persists in the Power Pivot model.
How can I resolve this issue and remove the redundant Table1 from Power Pivot without affecting the main table (Table) or its data?
I suspect you renamed the query and then loaded it to Power Pivot again. So, there's one query that has generated two tables.
Go to the Data tab in Excel > Queries & Connections. In the Queries & Connections pane open the Connections tab. Right-click on the connection you don't want > Delete.
Mynda
