Forum Discussion

apaceAW's avatar
apaceAW
Regular Visitor
1 year ago
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...
Need Help
  • lbendlin's avatar
    lbendlin
    1 year ago
    Parameters for range start and range end applied to the last_updated_date in the table

    Let 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.

     

     

lbendlin's avatar
lbendlin
Super User
1 year ago

No. There will be (at least) seven queries against the data source, each for a single day partition.

apaceAW's avatar
apaceAW
Regular Visitor
1 year ago

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! 

  • lbendlin's avatar
    lbendlin
    Super User
    1 year ago
    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.