Forum Discussion
PowerUser123
Helper II
Helper IIIncremental 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 ...
amitchandak
Super User
Super UserPowerUser123 , 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