Forum Discussion
Problem with incremental refresh on power bi premium
- Anonymous7 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.
Hi oscarmqz
yes my problem was resolved by adding a new column (dateLastUpdate) that i used for my RangeStart and RangeEnd filter
this column isn't updated in the source data, it shows only the last date of the update
please refer to this documentation
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#filter-date-column-upd...
regards
Hi,
i know this is an older thread, but when you say you created a dateLastUpdate column and that it is not updated in the source, how exactly are you generating that column? Also, what column are you using for the incremental filters?
thanks
Scott