Forum Discussion

Another_User's avatar
Another_User
Frequent Visitor
2 years ago
Solved

Regarding Incremental updates

Hello.   I have a doubt about incremental updates. One of my dashboards fetches data from a table that is renewed every day with new data (the number of users of a serie of stores and more details)...
  • lbendlin's avatar
    lbendlin
    2 years ago

    The more complicated answer is that no, this will not work.  Power BI is not a storage solution. You MUST keep your snapshots/historical data further upstream. The moment you make structural changes to your report and publish this to the workspace your incremental refresh will reset and all your old data will be lost.

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Another_User ,

    The answer is no, incremental refresh has a 'scrolling window mode'. As the refresh time passes, when a history partition is no longer within the history period defined by the policy, it is completely removed from the model. This will result in incorrect data on your expectations.

    Regarding the issue of incremental refresh, I hope you read the following documentation:

    Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn

     

    Best Regards,
    Wenbin Zhou
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.