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 
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!

Thanks 
Cheri Srikanth