Powerbi Incremental refresh duplication key issue

[tehseennawaz]

My powerbi report is connected to sql database. I had implemented incremental refresh with following configuration.

= Table.SelectRows(Navigation, each [LastAccessTime] >= RangeStart and [LastAccessTime] < RangeEnd)

Archive data value = 6 months

Incrementally refresh data value = 7 days

I had set RangeStart and RangeEnd very close just to load one day data on my machine and after deployment it will eventually refresh last 6 month data.

RangeStart = 1/1/2023 12:00:00 AM

RangeEnd = 1/2/2023 12:00:00 AM

But when i pushed report and refresh it. The report refresh cycle failed with this error:

Data source error: Column 'ApplicationMetadataID' in Table 'ApplicationMetadata' contains a duplicate value '8f0d314281fb60dbee4e450dc3f68f' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table.

I had check in sql database ApplicationMetadataID is primary key and there no duplicated record with this key.

[sergej_og]

Hey @tehseennawaz ,
I think I know what you are facing.

Does the value of your column "LastAccessTime" change?
It sounds like the content is changing. 
Am I correct in my assumption?
If yes, then this is the reason for the message.
I have already played through such scenarios several times.