Forum Discussion
Problem with incremental refresh on power bi premium
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, all works correctly but when I publish, the data is duplicated (for example on 2019-07-01 the amount of sales is duplicated by, 2)
Have you an idea about this problem?
The refresh of data is done every 30minute and the data is duplicated by 2 every time.
Thanks in advance for your help
SLI
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.
13 Replies
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
hi SLI
please refer this documentation for configuration
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#refresh-ranges
Important
Thanks
- Hi thanks for your reply
I am based on this article to set up the incremental refresh
Any one encountered the same problem??
Thankshi 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.
That last comment from oscarmqz IS THE SOLUTION. Thanks
