Incremental Refresh - Dynamically Changing the Refresh Start Date

[dancarr22]

Hello,

We have incremental refresh set up on a table.  That works.  But, we would like to dynamically change the start date.  Usually it is only within last 30 days.  But, once per week we'd like this to go back 730 days - as occasionally there are back-dated records.  How can this be done?  Note - we cannot change the db to lok at another field like audit date or anything.  Appreciate any help you can offer on this.

One other related question:  We have quite a bit of history in the table already.  Goes back many years.  Does the amount of data in the table that we are not refreshing impact the speed of the refresh.  i.e. If we are refreshing 30 days of data (2000 records) go slower if we have 3m records in the table which are archived/not refreshed?

Thanks,

Dan

--need to dynamically modify the red marked items below.

[dancarr22]

Thanks @amitchandak  - though not clear how your answer allows us to dynamically change the # of days (or date range) .  So, in screenshot above (yellow highlighted fields) where we have the 30 days.  We would occasionally like to change this to 180 or some other number.  Don't want to have to go in and recreate the PBI file every time we do this.  Can this reference a SQL field or formula so it's dynamic/flexible?

Thanks,

Dan

[amitchandak]

@dancarr22 , Change the setting once and publish, refresh and revert back and publish.

More data means more time.