Can we use Dataflow and Incremental Refresh to create a Historical Table?

[Halloween]

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.

[v-yueyunzh-msft]

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:

Chris Webb's BI Blog: Keep The Existing Data In Your Power BI Dataset And Add New Data To It Using I...

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