Forum Discussion
What does RangeEnd actually represent in the context of incremental refresh?
Hello,
What does RangeEnd actually represent in the context of incremental refresh?
I can't figure out what I should put in the RangeEnd parameter.
I'm looking to activate incremental refresh on my dataset, I put a RangeStart =>(After or equal) 01/10/2021 and a RangeEnd <(before) 31/10/2022.
I configured the incremental refresh over the last 12 months to have a rolling year.
My dashboard is updating on the PowerBi service (Pro by user account), but I don't have the data after 31/10/2022. I expect to have today's data from the time of the refresh with the previous 12 months.
Could you help me please ?
Thanks!
Hi Anonymous ,
1. Incremental refresh is configured in Power BI Desktop and performed in Power BI Service.
2. The values of the two parameters (RangeStart & RangeEnd) can be set to any value, as they will be overwritten by subsequent settings.
"Then create two parameters of DateTime data type, with names of RangeStart and RangeEnd, set a default value for each too. The default value can be anything, but the name and the data type should be as mentioned here."RangeStart should be entered a start date/time value.RangeEnd. should be entered end date/time value.then filter the data to be loaded into the model based on those parameters."After doing this action, your data in the table will be filtered based on the default values you have set for the RangeStart and RangeEnd parameters. However, don’t worry about that. these two parameters will be overwritten with the configuration you make in the Incremental Refresh setting of the Power BI Desktop."For more, you can refer to this article, which is very detailed:Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi Anonymous ,
1. Incremental refresh is configured in Power BI Desktop and performed in Power BI Service.
2. The values of the two parameters (RangeStart & RangeEnd) can be set to any value, as they will be overwritten by subsequent settings.
"Then create two parameters of DateTime data type, with names of RangeStart and RangeEnd, set a default value for each too. The default value can be anything, but the name and the data type should be as mentioned here."RangeStart should be entered a start date/time value.RangeEnd. should be entered end date/time value.then filter the data to be loaded into the model based on those parameters."After doing this action, your data in the table will be filtered based on the default values you have set for the RangeStart and RangeEnd parameters. However, don’t worry about that. these two parameters will be overwritten with the configuration you make in the Incremental Refresh setting of the Power BI Desktop."For more, you can refer to this article, which is very detailed:Best Regards,
Community Support Team _ CaitlynIf this post helps then please consider Accept it as the solution to help the other members find it more quickly.