Important Considerations for Setting up Incremental Refresh on Power BI Desktop

[sarava8304]

Hi,

I have setup an incremental refresh for 31 days and enabled "Detect data changes" & "Refresh Complete Days". But i see the Fact data in the model is exactly doubled, but when i verifiy with my desktop file the count is correct.

Please suggest whether the Complete Days refresh is making this double values?

thanks,

Saravanan R

[JontyB]

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 

[Anonymous]

Thank you.. I also fixed this issue.. Soory I didnt updated in this blogs..

Thanks for reminding me 👍