Forum Discussion
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
3 Replies
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
- 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?
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
