Forum Discussion
Solved
Power BI Incremental Refresh Behavior Question
Hello. I'm trying to understand the behavior of Power BI's incremental refresh functionality. I'm not a Power BI developer but I have a decent understanding of the basics. Here's the setup in the...
Parameters for range start and range end applied to the last_updated_date in the tableLet me stop you right there. last_updated_date is not a suitable column for incremental refresh partition policies. This will result in data duplication across partitions. Instead use an immutable column like created_date.
Thank you for the response. I guess my question is more simple than this. If we specify the range on the created_date and it's set to pull 7 days, the query that is fired off to the source is going to look for anything with a created_date in the last 7 days?
lbendlin
Super User
Super UserNo. There will be (at least) seven queries against the data source, each for a single day partition.