Table exist in Power Pivot but not in Power Query

[wep]

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.

[ThxAlot]

It's normal, unlike PBI, you can directly add table to data model in Excel.

[wep]

The table does not exist in an excel sheet either.

Do you have any suggestion on how i can delete the table?

[ThxAlot]

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.

[wep]

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