Forum Discussion

Halloween's avatar
Halloween
Frequent Visitor
4 years ago

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 ...
dataflow
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Icon for Community Support rankCommunity Support
4 years ago

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 Incremental Refresh Chris Webb's BI Blog (crossjoin.co.uk)

 

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