Forum Discussion

AnandGNR's avatar
AnandGNR
Icon for Helper I rankHelper I
4 years ago

Incremental Refresh takes almost same time as Full refresh in PBI Service

Hi, I have set up incremental refresh on 2 fact tables that are part of my dataset. I have given an active range of 12 months with an archive of 2 years and use LastModified to detect changes. I kno...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

You cannot use UpdateDate for incremental refresh, that will lead to data duplicates. Use something immutable like CreatedDate.

Prachi0202's avatar
Prachi0202
Frequent Visitor
2 years ago

Update date is the date when data is loaded from source to the destination so I think its same a the created date, and we have Incremental Refresh set just for a day.