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

     

6 Replies

    • laq2025's avatar
      laq2025
      New Member
      1 year ago

      Thanks for the link! But the setting does not include future dates in the refresh? Only incrementally refresh data starting x days before refresh date?

  • Akash_Varuna's avatar
    Akash_Varuna
    Super 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

     

  • v-csrikanth's avatar
    v-csrikanth
    Community 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.

  • v-csrikanth's avatar
    v-csrikanth
    Community 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

  • v-csrikanth's avatar
    v-csrikanth
    Community Support
    1 year ago

    Hi 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.