Forum Discussion

skootz's avatar
skootz
Frequent Visitor
6 years ago

Incremental refresh - power bi refresh automatically

Good morning all , I implemented an incremental refresh. https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/ I created 3 tables a "don'trefresh", a "refresh" and...
Need Help
ImkeF's avatar
ImkeF
Community Champion
6 years ago

Hi skootz ,

sorry, but I don't have a solution for this.

 

skootz's avatar
skootz
Frequent Visitor
6 years ago

Incremental refresh stores daily (if set like that) new records based on a RangeStart and RangeEnd (date / time) filter ?  I ask it to update every day and store me on 5 years but it does not store anything it updates the table for me and deletes the records from 08/31 when it should keep them.

 

Thanks,

  • v-xicai's avatar
    v-xicai
    Community Support
    5 years ago

    Hi skootz ,

     

    The filter on the date column is used to dynamically partition the data into ranges in the Power BI service. Incremental refresh isn't designed to support cases where the filtered date column is updated in the source system. An update is interpreted as an insertion and a deletion, not an actual update. If the deletion occurs in the historical range and not the incremental range, it won't get picked up. This can cause data refresh failures due to partition-key conflicts.

     

    For reference:

     

    Incremental refresh in Power BI

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.