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

     

v-csrikanth's avatar
v-csrikanth
Icon for Community Support rankCommunity Support
1 year ago

Hi laq2025 
As highlighted by Akash_Varuna , the proposed approach appears to effectively address your requirements.
Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.

Thanks and Regards,
Cheri Srikanth.