Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
joshua1990
Post Prodigy
Post Prodigy

Setting up Incremental Refresh for Weekly Archive

Hi experts!

I need some guidance for setting up an incremental refresh.

I have a table that stores the sales data each week for last week:

Extract DateSales DataValue
01.07.202426.06.20245
01.07.202427.06.20247

 

The extract date shows the date for the archive.

Now I would like to update the last 2 weeks based on the column and to store the last 2 years.

How would I need to define RangeStart and RangeEnd for that column and what do I need so define in the incremental refresh settings in the end?

2 ACCEPTED SOLUTIONS

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.

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.