Forum Discussion
incremental refresh
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.
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.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.
4 Replies
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 Advancehi 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?
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.
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.
