Forum Discussion

PowerBI123456's avatar
PowerBI123456
Post Partisan
5 years ago

Incremental Refresh 2 days

Hi - Is there anyway to have 2 RangeStart dates for incremental refresh. There is one data source that I need to go further back on to get some historical user activity. Thanks!

1 Reply

  • DataZoe's avatar
    DataZoe
    Microsoft Employee

    Hi PowerBI123456 , there is only one RangeStart specified, but then for each table you can specify how far back you want to refresh everyday and also how far back you want to store. For example, in your Users table you can have it refresh 7 days and store 2 years, but for your Sales table you can have it refresh 2 months, and go back 10 years.