cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SLI Regular Visitor
Regular Visitor

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, 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
1 ACCEPTED SOLUTION

Accepted Solutions
LW Member
Member

Re: 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. 

5 REPLIES 5
LW Member
Member

Re: Problem with incremental refresh on power bi premium

SLI Regular Visitor
Regular Visitor

Re: Problem with incremental refresh on power bi premium

Hi thanks for your reply
I am based on this article to set up the incremental refresh
Any one encountered the same problem??

Thanks
LW Member
Member

Re: 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. 

oscarmqz Frequent Visitor
Frequent Visitor

Re: Problem with incremental refresh on power bi premium

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

Highlighted
SLI Regular Visitor
Regular Visitor

Re: Problem with incremental refresh on power bi premium

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 

Helpful resources

Announcements
Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 286 members 3,177 guests
Please welcome our newest community members: