Forum Discussion
Table exist in Power Pivot but not in Power Query
Good morning,
i am facing a problem with a table that i deleted from the query editor.
It seems that the table still exist in the power pivot editor because i see it in the data model but the same table does not exist in the query editor.
When i try to delete the table from the data model i get the error message "The table was created from a query. To change the table you need to change tha query".
I dont know then how to delete this table.
4 Replies
It's normal, unlike PBI, you can directly add table to data model in Excel.
The table does not exist in an excel sheet either.
Do you have any suggestion on how i can delete the table?
You can't find it doesn't mean it doesn't exist. There are some tricks to hide it, eg set visibility status of a worksheet to xlVeryHidden and set an Excel table in this worksheet.
If you wanna delete it, try to delete it from data model.
