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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. 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
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.

May 2025 Monthly Update

Fabric Community Update - May 2025

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