Forum Discussion

PowerUser123's avatar
PowerUser123
Icon for Helper II rankHelper II
3 years ago

Incremental Refresh - Subset of Data

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?

Need Help

1 Reply

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    3 years ago

    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