Forum Discussion
Solved
Reload only one year data using dataflow while remianing past years data is same
I am loading General Ledger table into Fabric Lakehouse using dataflow and everyday and published Power BI model is refreshing only 2024 data through incremental refresh while 2020, 2021, 2022, 2023 ...
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
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.
I could not see the option for Incremental Refresh in Fabric dataflow Gen2.