Incremental refresh

[laq2025]

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

[v-csrikanth]

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.

[v-csrikanth]

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]

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.

[Akash_Varuna · Accepted solution]

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

[rubayatyasmin]

Hi,   

This article will help you. Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

@laq2025

[laq2025]

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?