Delete table in Power Query

[Vallirajap]

Hii,
I have one table in Power query,
Now I reffer the table to create another table

is there any table functions to delete the existing table in advance editor 

Thanks in Advance

[mussaenda]

Hi @Vallirajap,

Which one do you want to delete, the first table used for reference or the second table from the original table.

If you want to delete the first table that you are using as reference, well you can't.

You are refering to it. How you are going to refer to it if you will delete it?

One thing you can do is to hide it.

If you want to delete the second table where the data are being referred from the first table,

then you can. 

Hope this helps

[AlienSx]

hello, @Vallirajap Power Query is ETL tool, it's not a table holder. It can extract data from various data sources (E), transform (T) and load them to Excel ss/Excel PP model/Power BI model (L). This is what ETL stands for.