The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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.
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.