Forum Discussion
Advocate IDoes incremental refresh do anything if I don't have a data destination ?
Hi mrozzano ,
Incremental Refresh requires a data target to operate effectively. Without a data destination, the Incremental Refresh setting will have no place to store the refreshed data, rendering the setting invalid.
In your scenario, Dataflow A has incremental refresh enabled but no target, while Dataflow B gets data from Dataflow A and Dataflow B's target is a datalake repository. Due to the lack of a target to store the refreshed data, the incremental refresh in Dataflow A won't actually do anything.
For incremental refresh to work properly, you need to ensure that the Dataflow has a valid target so that the refreshed data can be stored and accessed by subsequent Dataflows or reports.For more details, you can refer to below document:
Incremental refresh in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi mrozzano ,
Incremental Refresh requires a data target to operate effectively. Without a data destination, the Incremental Refresh setting will have no place to store the refreshed data, rendering the setting invalid.
In your scenario, Dataflow A has incremental refresh enabled but no target, while Dataflow B gets data from Dataflow A and Dataflow B's target is a datalake repository. Due to the lack of a target to store the refreshed data, the incremental refresh in Dataflow A won't actually do anything.
For incremental refresh to work properly, you need to ensure that the Dataflow has a valid target so that the refreshed data can be stored and accessed by subsequent Dataflows or reports.
For more details, you can refer to below document:
Incremental refresh in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Advocate IThank you for clarifying !
Some feedback : Because a data destination is required to use incremental refresh, I suggest dimming / disabling that menu item until an oppropriate data destination (warehouse, Azure SQL db) is selected. Then, make incremental refresh selectable / enableable.
Otherwise, it contradicts the documentation or causes confustion : I've enabled incremental refresh without selecting a data destination. Hence my question, is it doing anything ?