Forum Discussion

Dat8Enthusiast's avatar
Dat8Enthusiast
Regular Visitor
1 year ago
Solved

Datamart Incremental Refresh is Failing

I set up some tables in one of my datamarts to refresh incrementally with the below settings. After the schedule refresh, I can see today's and yesterday's data. But after some time, the previous day...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    I also tried changing the refresh period for different values, and the datamart is spontantenously updated (deleting old data) even without a refresh.

    That is working as designed. Any meta data change will result in a reset of the incremental refresh partitions and a rebuild on the next refresh.

     

    Incremental refresh is for import mode only.  (Small exception when you have a "live"  "today"  partition that is working in Direct Query)

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago
I also tried changing the refresh period for different values, and the datamart is spontantenously updated (deleting old data) even without a refresh.

That is working as designed. Any meta data change will result in a reset of the incremental refresh partitions and a rebuild on the next refresh.

 

Incremental refresh is for import mode only.  (Small exception when you have a "live"  "today"  partition that is working in Direct Query)

 

 

Dat8Enthusiast's avatar
Dat8Enthusiast
Regular Visitor
1 year ago

In my use case, the datamart loads the data from another dataflow. And it seems like dataflows as a source don't support that storage mode even with the three storage modes are still showing as valid options.