Incremental refresh setup for the future year

[anusha_2023]

I have created RangeStart and RangeEnd parameters for incremental refresh and I want to incremenrally refresh last 25months that is 2024 Dec 1st to 2026 Den 31st while other values are constant.

When configuring the Incremental refresh I could only set until current year as below. But I want to refresh entire 2025 and 2026 as well.

How can I include future year in the incremental refresh?

[AnkitKukreja · Accepted solution]

Hi! @anusha_2023 

Your end-date parameter will decide the refresh parameter for our case. And you should use days in your incremental refresh period or when your data changes. There is no point to use 2 years, else you'll not utilizing your complete data, it's refreshing your complete 2 yrs data.
Please go through this doc for better understanding, ou can change that time period and your Range end parameter will ensure your refresh is being done until the last day.

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview#create-paramete...