Removing tables from power query after appended table

[earthworm]

I have 20 tables with huge data that cannot be exported into excel sheet.
I have appended all the tables into single table. Now once the appended data Is ready I need to remove all the 20 tables that I have appended and want to keep only single table now. I cannot delete the other tables because it's connected to appended table. Please guide.

 

[ExcelToDAX]

They will have to be in the Power Query logic still, but you can delete all of the 20 tables from the Excel sheets and make them "Connection only" tables and only load the final appended table to an Excel sheet

 

[earthworm]

They will have to be in the Power Query logic still, but you can delete all of the 20 tables from the Excel sheets and make them "Connection only" tables and only load the final appended table to an Excel sheet

I understand but this is not what I want. Is it possible that I import the appended once into data model and then delete all?

 

[earthworm]

Anyone please help . I cannot import data into sheet . i need to import on backend only