Forum Discussion
Solved
Incremental refresh
Hi, Could anyone please help with this? I need to set up an incremental refresh from 3 days before refresh date to 1 year after refresh date. How could I accomplish this? Thanks, Linda...
Hi laq2025 , Could you please try this
Create Parameters:RangeStart (e.g., 1/1/2024)
RangeEnd (e.g., 12/31/2024)
Filter Query in Power Query:
Table.SelectRows(Source, each [DateColumn] >= RangeStart - #duration(3, 0, 0, 0) and [DateColumn] <= RangeEnd + #duration(365, 0, 0, 0))
Set Incremental Refresh:
Keep data for 1 year.
Refresh data from 3 days before today.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance
v-csrikanth
Community Support
Community SupportHi laq2025
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you,
Cheri Srikanth.