Incremental Refresh - Subset of Data

[PowerUser123]

Say you have a SQL database that has data going back to the year 2000, however, you only want to keep data from 2016 and on in your data model. Can you first apply a filter to the table for anything greater than or equal to 2016 and then apply incremental refresh policies after that?

Or will incremental refresh policies ignore the first filter of >= 2016 and try to refresh the entire database going back to 2000 when doing the first full refresh for incremenal refresh?

[amitchandak]

@PowerUser123 , In incremental it will how many years of data you want to keep, so it will automatically move to 2017 after 1 year . You have an option 6 years there

Power BI Incremental Refresh Pro; Premium Deployment pipeline - https://youtu.be/nIxTRdeCYSE

Filter in query of connection (advance option) or filter added in power query can help