incremental refresh

[Hussein_charif]

i have a dataset that i want to apply incremental refersh to. i checked the microsoft forums 

https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure

i was wondering if it is possible for the range end to not be hardcoded? for example if the data is ranges between 2020 and 2024, i have the start and end date, where the data before 2024 would be archived. let's say there is a possibility that new data >2024 is added from the client's side, i want my range end to be updated automatically, so i cant have it hardcoded.

[Anonymous · Accepted solution]

Hi @Hussein_charif 

The RangeStart and RangeEnd parameter values that you create in the Power Query Editor are used to filter the data loaded into the model before refreshing, and the incremental refresh policy overrides these time range values when you set up the incremental refresh policy and publish to the Service. So, the time ranges are automatically updated according to your incremental refresh strategy.

Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Hi @Hussein_charif 

The RangeStart and RangeEnd parameter values that you create in the Power Query Editor are used to filter the data loaded into the model before refreshing, and the incremental refresh policy overrides these time range values when you set up the incremental refresh policy and publish to the Service. So, the time ranges are automatically updated according to your incremental refresh strategy.

Configure incremental refresh for Power BI semantic models - Power BI | Microsoft Learn

Best Regards,
Jarvis Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Akash_Varuna]

Hi @Hussein_charif  Incremental refresh in Power BI automatically adjusts the range end based on the latest data in the source; you don't need to hardcode it. Just make sure to set RangeStart and RangeEnd parameters are set dynamically, and new data beyond the current range will be included during refresh.
If this post helped please do give a kudos and accept this as a solution
Thanks In Advance

[Hussein_charif]

hi @Akash_Varuna , thank you for the reply. 

by set dynamically, what do you mean exactly?

so i just set the start and end date based on my date min and max in the table and it'll automatically update?

[Akash_Varuna · Accepted solution]

Hi @Hussein_charif , You will have to create parameters in power query here are the steps 

• Create Parameters:

  • Open Power Query in Power BI Desktop.
  • Go to the Home tab and click Manage Parameters > New Parameter.
  • Create two parameters:
    • RangeStart 
    • RangeEnd 

• Apply Filters in Power Query:

  • Select your date column in the table.
  • Apply a filter:
    • Date >= RangeStart.
    • Dtae < RangeEnd.
  • This ensures only rows within the dynamic range are loaded.

• Enable Incremental Refresh:

  • Close Power Query and save changes.
  • In Power BI Desktop, right-click your table and select Incremental Refresh.
  • Enable the toggle and specify the refresh/archival periods.