Forum Discussion

RoopaR's avatar
RoopaR
Advocate I
5 years ago
Solved

incremental refresh on a non-date integer column

Hi,   I have a need to do incremental refresh (daily cadence) on my datasets based on a non-date integer column (bigint) We have time series data that's loaded on to SQL server that sometimes miss...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    You can't. Incremental refresh is timestamp based. 

     

    Can you use a different timestamp, like "Record received"  ?  

lbendlin's avatar
lbendlin
Super User
5 years ago

You can't. Incremental refresh is timestamp based. 

 

Can you use a different timestamp, like "Record received"  ?  

RoopaR's avatar
RoopaR
Advocate I
5 years ago

Thank you lbendlin for the suggestion. By adding a record_ received column at source I can set up incremental refresh. Didn't think of that earlier. Appreciate your input!