March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe 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
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 Date | Sales Data | Value |
01.07.2024 | 26.06.2024 | 5 |
01.07.2024 | 27.06.2024 | 7 |
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?
Solved! Go to Solution.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.
User | Count |
---|---|
37 | |
22 | |
20 | |
10 | |
9 |
User | Count |
---|---|
59 | |
55 | |
22 | |
14 | |
12 |