Forum Discussion

laq2025's avatar
laq2025
New Member
1 year ago
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...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    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

     

Akash_Varuna's avatar
Akash_Varuna
Icon for Super User rankSuper User
1 year ago

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