Forum Discussion
Solved
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 ...
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! 😁
Hi,
I double checked your metioned setting this morning. I'm already selecting replace for tables.
Have a nice day.
Hi BeyzaKzlky
Apologies for the issue you have been facing. Are you still facing this issue?
If yes we will respond back with more details and try to help.
Thanks.