Forum Discussion
Problem with incremental refresh on power bi premium
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 SLI
please refer this documentation for configuration
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#refresh-ranges
Important
Thanks
I am based on this article to set up the incremental refresh
Any one encountered the same problem??
Thanks
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, I have the same problem, were you able to fix this? I have a single INSERT_DT column which I am using for my RangeStart and RangeEnd filter, my settings are keep last 2 years of data and refresh for the last 2 days. It runs once a day, but all the daily snapshots are getting duplicated
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
