Delete an Excel Power Pivot Table Controlled by Power Query
Question details
The user needs to remove a table from Excel's Power Pivot Data Model, but the table is controlled by a Power Query connection.

- Product
- Microsoft Excel Power Query and Power Pivot
- Device & OS
- not provided
- Scenario
- Deleting a Data Model table that was created and loaded by Power Query.
- Observed behavior
- Power Pivot prevents direct deletion because Power Query controls the table.
Identify the query that loads the table and check whether other queries, relationships, measures, or PivotTables depend on it. Excel's connection-management commands vary by version: look for Data > Queries & Connections or Data > Connections.
Remove the table through its source Power Query
Use this method when Power Pivot blocks deletion because Power Query owns the table's load connection.
A table loaded by Power Query is managed through its source query and load settings, rather than directly in Power Pivot. Deleting the query removes its refresh logic and can affect dependent workbook content.
In Excel, open Data > Queries & Connections and select the Queries tab. Identify the query that loads the unwanted table. In versions with Data > Connections, select the relevant connection and inspect its Properties to help identify the source.
Right-click the query and select Edit to inspect its source and applied steps. Confirm that it supplies the table you want to remove, then close the Power Query Editor without changing the query.
In Data > Queries & Connections, right-click the identified query and select Delete. Read the confirmation message and confirm only if you no longer need the query or its loaded data. If Excel reports dependent queries, review those dependencies before proceeding.
Open Power Pivot > Manage and check whether the table is gone. Also check any PivotTables or measures that used it. If you removed only a connection through Data > Connections and the table remains, return to the source query and review its load settings rather than assuming connection deletion removed the model table.

Use WPS Spreadsheet for Everyday Excel Workbook Editing
WPS Office is a free, lightweight alternative for everyday spreadsheet work, with a familiar interface and Excel format compatibility that makes migration easier. It does not fix Excel's Power Query-controlled Power Pivot table deletion issue; complete that operation in Microsoft Excel.

Frequently Asked Questions
Why can't I delete this table directly in Power Pivot?
The table was loaded by Power Query, so its source query controls the load operation. Open Excel's Data > Queries & Connections and manage the query there instead of deleting the table directly in Power Pivot.
Can I keep the query but stop loading its table into the Data Model?
Where your Excel version allows it, right-click the query in Data > Queries & Connections and select Load To. Choose Only Create Connection and clear Add this data to the Data Model. Read any warnings before confirming, because removing the model table can affect relationships, measures, and PivotTables. Available options vary by Excel version and the existing load configuration.
Will deleting the query affect my PivotTables?
It can. PivotTables, relationships, and measures that reference the removed table may no longer work correctly. Before selecting Delete in the Queries & Connections pane, review the table's relationships in Power Pivot > Manage > Diagram View and identify PivotTables that use its fields.
What should I check if Excel still refuses to remove the table?
Confirm that you selected the correct source query under Data > Queries & Connections and inspect any dependency warnings. Test whether the same behavior occurs in a new workbook. For further support, provide the exact error message and your Excel version from File > Account > Product Information, where available.




