Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Praveen_Rangu
Frequent Visitor

Getting error in Table column contains a duplicate value, during incremental refresh

Praveen_Rangu_0-1718193965493.png

@lbendlin 

I am a pro PowerBI user and use RangeStart <= [partition date] < RangeEnd in this way. 
Even after doing in that way, I am getting the same error. Will it happen if that unique ID is present in archived data and got updated in a recent refresh 

Currently, I am using modified date to fetch data and detect changes. Instead, can I use created at date to fetch data and modified at date to detect changes. Will I escape from duplicate error.

Data source error: Column '<oii>class_id</oii>' in Table '<oii>dw v_fact_classes</oii>' contains a duplicate value '1333550' 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.


3 REPLIES 3
lbendlin
Super User
Super User

Will it happen if that unique ID is present in archived data and got updated in a recent refresh 

Yes, it will. Remember this is incremental refresh, not differential refresh.  Incremental refresh only works with immutable data, If your data is mutable you need to manually refresh all affected partitions.

Anonymous
Not applicable

It is not allowed probably because it has a relationship to another table and this table is the one side of a one to many or one to one. Scroll to the right to see the rest of the error.

 

Or you mayve have to change the relationship to many to many or reverse the one to many if this is the fact and the other table is the dimension

I have updated the full reason.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.