Forum Discussion
Setting up Incremental Refresh for Weekly Archive
I believe the documentation describes the process well. Here is the short version:
- you create RangeStart and RangeEnd parameters in Power Query, set them as datetime, and specify default values that give you enough data to develop with (these default values will be ignored during the actual refresh)
- you add a filter step in your Power Query with an appropriate datetime column (for example Order Date). Make sure to set RangeStart to inclusive and RangeEnd to exclusive. RangeStart <= [Order Date] and [Order Date]<RangeEnd
- then in Power BI you set the table to incremental refresh for 14 days and storage for 2 years.
Incremental Refresh does not have weekly partitions. Best you can do is refresh 14 days and keep 2 years.
That is fine. But how would you setup the parameters, filters and the settings in the end?
I believe the documentation describes the process well. Here is the short version:
- you create RangeStart and RangeEnd parameters in Power Query, set them as datetime, and specify default values that give you enough data to develop with (these default values will be ignored during the actual refresh)
- you add a filter step in your Power Query with an appropriate datetime column (for example Order Date). Make sure to set RangeStart to inclusive and RangeEnd to exclusive. RangeStart <= [Order Date] and [Order Date]<RangeEnd
- then in Power BI you set the table to incremental refresh for 14 days and storage for 2 years.
