Forum Discussion
Reload only one year data using dataflow while remianing past years data is same
You may have wanted to mention that you need this for DF Gen 2. The concept there is slightly different. Note the limitations.
Incremental refresh in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn
I have a dataflow in the Fabric Workspace which is loading 2021 to 2024 all the time. I want to add changes to the dataflow where 2021 to 2023 need to be constant and 2024 need to be updated for each data load.
Configure your incremental refresh to keep the last five years and refresh the last two years?
How can I configure the Incrementa refresh inside dataflow to keep first 3 years constant and 2 years reload for each run. Could you please share me the steps to work on.
Note that you get one more year partition "for free" because the 5 years is counted back from Today() and therefore includes a small part of 2019. That partition will drop off on Jan 1st.