Forum Discussion
BeyzaKzlky
2 years agoFrequent Visitor
Dataflow Gen2 Incremental Refresh and Data Refresh
Hi all, I have a problem again with dataflow gen2. I'm getting my data from on-prem sql server with dataflow, and because there is no Incremental refresh on gen2, I set standard scheduled refresh ...
- 2 years ago
Hi!
My name is Jeroen Luitwieler, and I’m a Senior Product Manager on the Dataflow team. While this guide shows how to use an OData source, it’s just an example. You can use this method with your on-premises SQL Server without any issues. If you want to perform a full refresh of your data every time you refresh, you can change the current data destination setting from “append” to “replace”.
Hope this resolves your issue! 😁
ebjim
2 years agoResolver I
Incremental updates is similar to implementing SCD type 2. This might be useful: