Forum Discussion

danielroca's avatar
danielroca
New Member
6 years ago
Solved

Incremental Refresh by Audit Fields

Hello everyone,   I am configuring the incremental refresh for a fact table that models forecasted data. This means that it has future dates. The documentation (Incremental refresh - JSON for futur...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    Incremental refresh is designed for (very) slow changing data, close to immutable.  Stuff that you receive once and that then doesn't ever change again.

     

    Why don't you put your historical (immutable) data in one table with incremental refresh and your forecast data and other mutable data in another table without incremental refresh?  You can union the tables in Power Query if needed.

lbendlin's avatar
lbendlin
Super User
6 years ago

Incremental refresh is designed for (very) slow changing data, close to immutable.  Stuff that you receive once and that then doesn't ever change again.

 

Why don't you put your historical (immutable) data in one table with incremental refresh and your forecast data and other mutable data in another table without incremental refresh?  You can union the tables in Power Query if needed.