Forum Discussion
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 ...
Hi GilbertQ Thanks. But this does not take care of my scenario. If only depends on Max date in "Changes detected". If my date column is not falling in the rangeof teh incremental refresh cycle , it will still miss the older rows.
Let me know if I missed something
Hi there
My understanding is that it will also look for changes to the changed column and if it is newer than the last date, it will process that data too?
My understanding is that it will also look for changes to the changed column and if it is newer than the last date, it will process that data too?
Yes it does.. but you will need another date column thats different from the Incremental refresh date.
Do you have any example or scenario that can help me understand how to use this option?- Hi there
Here are more details on how it works
https://docs.microsoft.com/en-us/power-bi/service-dataflows-incremental-refresh