Forum Discussion
Can we use Dataflow and Incremental Refresh to create a Historical Table?
Hi guys
I am wondering if we could utilise Power BI Dataflow and Incremental Refresh to create a cumulative table (Historical Table)?
Let's say I want to have a Table that will contains all the records from a daily snapshot of a table.
e.g. I want to store all the records in Table A by doing a snapshot refresh every day (select * from A) as the values of some columns in Table A could be changing every day.
Suppose Table A contains 5 columns (CreatedOn, ModifiedOn, ID, Customer Name, Status)
I setup a Daily Refresh ah 9 PM. I am expecting the resulting Table is Table B in PowerBI Service would have like this:
Extracted Date (The Snapshot Date - additional Column), and all columns from Table A (CreatedOn, ModifiedOn, ID, Customer Name, Status)
Thank you so much.
1 Reply
- v-yueyunzh-msft
Community Support
Hi , Halloween
For your need , you want to add a cloumn in your table when you set the incremental refresh . Right?
As researched , you can refer this document about dataset , i hope that may help you:
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
