append local table and save

Good evening,

I have data stored on an SQL server

Once per day l Ioad various database tables which i then manipulate and store in a single pivot table (say X).

I would like to append the pivot table data, which is one row with various colums, in a table (say Y) which has been created in PBI desktop.

The data  in Table Y should be saved so it can be appended the next days data (from X).

i manage to append, by using table.combine in a power query

I can manage to store the data in Table Y however

Any suggestion please?

Thx

Patrick