Forum Discussion
Incremental refresh with non-rolling archived data
- 4 years ago
For anybody interested, this is the solution I came up with.
The source is a SQL DB, and the table/view is set to accumulate data from January 1, 2018 onwards. So instead of going back 4 years to capture 2018, 2019, 2020 and 2021 into the archive in PBI, and loosing 2018 next year, I'll set that period to 7 years and will lose my 2018 only in 3 years.
What this will do is that because the source starts from 2018, the report won't have data before 2018 and the fact that it'll keep rolling for 3 years will not make me lose any data in the report dataset.
It doesn't have to be 3 years and can be any time period more than 4 years that I require in my dataset's archive. I'm taking 4+3, assuming that the report will have to be enhanced or modified during these additional 3 years anyway and then I can re-set the rolling period for the archive part again.
Here's the chart for the incremental plan:
If anybody has a better or an alternative solution, please share!
OB you can set incremental data set refresh for 1 year and that will take care of it, detail is in the same document.
✨ Follow us on LinkedIn and to our YouTube channel
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.