Important Considerations for Setting up Incremental Refresh on Power BI Desktop

Hi sarava8304 

I raised a question about incremental refresh a few days ago, as I was getting a similar issue, my data is using a timestamp in the database for when the row was last updated. Incremental refresh completes a delete and insert for only the days which you have specified in the refresh period, in my example I stored the last 10 years and refreshed the last 10 days. 

The issue I had was that a record which was older than 10 days was updated, this record was held in the stored dataset which is not deleted, it was then also added in the refreshed data, as it had been updated. This caused duplication in the final dataset and the refresh failed as my table was on the 1 side of a 1 to many relationship.

This is detailed in the incremental refresh doc here