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.
Ok so 7 (at least) queries for each day. Would that still be querying by created_date? I assume that to be the case since we haven't told it about any other date column. I think I'm rounding out my knowledge with your answers so thank you for your knowledge and support!
Ok so 7 (at least) queries for each day.Not 7 queries for each day. 7 queries, one for each day
Make sure RangeStart is inclusive an RangeEnd is exclusive - that will avoid duplicate data across partitions.