Forum Discussion

Rahul_SC's avatar
Rahul_SC
Icon for Helper IV rankHelper IV
4 years ago

Preserve 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 g...
Need Help
Tips and Tricks
Tutorial Requests
tackytechtom's avatar
tackytechtom
Icon for Most Valuable Professional rankMost Valuable Professional
4 years ago

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's avatar
    Rahul_SC
    Icon for Helper IV rankHelper IV
    4 years ago

    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.