Preserve historic data, incrementally refresh for new data

[Rahul_SC]

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!

[tackytechtom]

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_SC]

Hi, 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.