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 sa...
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.
As i stated in my first message i already tried to delete the table from the data model but i get the error message "the table was created from a query. Modify the query instead".