Forum Discussion

SLI's avatar
SLI
Helper IV
7 years ago
Solved

Problem with incremental refresh on power bi premium

Hi everyone I have a problem with incremental refresh on power bi premium. I have set an incremental refresh on my power bi desktop (the aim is to refresh data of 2 last days) . on power bi desktop...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    hi SLI 

    Do you have a specific date column defined as LastUpdated date and specified the incremental policy in a the relevant table? Also make sure you have loaded the hisotrical data and refresh rows in the last ( XX) days.  detect data changes also critical to LastUpdatedDate changes. 

oscarmqz's avatar
oscarmqz
Advocate II
6 years ago

The duplicated data is because of how you set up the filter. It as to be >= RangeStart and < RangeEnd. If you set >= and <= that's when you get dups

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thanks oscarmqz , that fixed my issue.

  • sujith31's avatar
    sujith31
    Frequent Visitor
    5 years ago

    Thank you.