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...
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".