Use incremental refresh on No of id's instead of date

[Avivek]

I had used incremental refresh on date column previously and am aware how it works. 

I have another model which works on a different concept. Here they have id's which increases every month where new id's are added at the month end every month.

I had given a rangestart as 100 and rangeend as 250, next month if i want it to see only those data's to refresh which are not in the filter between 100-250 then what is the filter I should define while adding it for the is column.

Is there anything different we may need to do in this case and most importantly will it work for id'd like it does for dates.

[d_gosbell · Accepted solution]

When you use incremental refresh the RangeStart / RangeEnd values will always be passed in to your query as datetime values. However if you have a reliable way of converting these into an integer value (such as doing a DATEDIFF in months since a given start date) then you can use an approach like this one https://docs.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure#convert-datetim... to create a function to convert the datetime values into an appropriate integer which should then be folded into the query against your data source.