Forum Discussion
Helper IVPreserve historic data, incrementally refresh for new data
Hi All,
I have a data connected with web. Need is when we refresh the query, it should preserve the historic data and get the latest data.
in the source web, after every week, historic data gets removed which we want to preserve using the query and save the new data as well which gets updated.
Thanks!
2 Replies
- tackytechtom
Most Valuable Professional
Hi Rahul_SC ,
I guess you are looking for the incremental refresh feature in PBI. Please, check out this video by Guy In A Cube:
Avoid the full refresh with Incremental Refresh in Power BI (Premium) - YouTube
Here another decent one:
How to use INCREMENTAL REFRESH for Datasets (PRO) and Dataflows (PREMIUM) in Power BI - YouTube
And there MS documentation:
Incremental refresh for datasets and real-time data in Power BI - Power BI | Microsoft Docs
Hope this helps!/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Rahul_SCHi, thanks for the links!
I know how to set up incremental refresh. But, I am looking for web connectivity source and incremental refresh with it. In all the tutorials, their source file is relational database for incremental refresh.
