append local table and save

[patfee]

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 

[patfee]

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 

[Greg_Deckler]

Sounds like a use case for the Preview feature for Incremental refresh. There are ways to use Append query to do this manually but it takes manual intervention. Is there a reason you can't just refresh the entire table?

[patfee]

the pivot table contains one row which include numbers for leads, registered rfq, rfq,s being worked on, issued rfq,s etc.

the other table, the one i would like to append on a daily basis, stores these rows.

so purpose is to build a history

data comes from a microsoft dynamic navs 2017 database btw. 

thx