Forum Discussion
petersmith
7 years agoNew Member
Dataflow incremental refresh with primary key
Hi All, Loving dataflows, but would love the ability to do an incremental refresh in more of an 'upsert' style. That is, maintain the uniqueness of a primary key within the dataset. Any ideas on ...
GilbertQ
7 years agoSuper User
Hi there
As it currently stands you have to use a DateKey in order to do the incremental refreshing.
THis will allow you to possibly only refresh the latest day. And with only having 1 million rows in total, it should be really quick.
As it currently stands you have to use a DateKey in order to do the incremental refreshing.
THis will allow you to possibly only refresh the latest day. And with only having 1 million rows in total, it should be really quick.