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.

Hi joshua1990 ,

You refer this- 

https://community.fabric.microsoft.com/t5/Power-Query/Incremental-Refresh-with-Year-Week-Column/td-p/2697852

Thanks,

Sai Teja