Forum Discussion

tehseennawaz's avatar
tehseennawaz
New Member
3 years ago

Powerbi Incremental refresh duplication key issue

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.

Need Help

1 Reply

  • sergej_og's avatar
    sergej_og
    Super User
    3 years ago

    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.