Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Incremental Refresh based on loaded date or a custom column

Hi, I would like to set up incremental refresh based on "loaded date".   My data set does not have a date in it, so, I add a new column, and fill it using M in the query editor Loaded = DateTime....
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thank you.

 

I Tried doing that, but the incremental refresh still did not work.

 

I was able to bring in the file attributes - date created, and then set up an incremental refresh on that column.

 

I loaded the data into my model, and published it.

 

To test it, I chnaged the data in an old file (that has a created date outside the incremental refresh settings), and then I refreshed the dataset.

The old data still refreshed.

 

Am I missing something or doing something wrong?