Forum Discussion

TusharGaurav's avatar
TusharGaurav
Helper III
2 years ago
Solved

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

Hi Experts,

 

I am trying to apply incremental refresh in few of the tables having huge volume of data.

While refreshing the dataset, I am getting the below error:

Column 'Product_Key' in Table 'Product Dimension' contains a duplicate value '34343434' 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 have checked in database and there is no duplicate records in either of the table.

Can you please suggest what could be the reason for this error.

 

Thanks and Regards,

Tushar Gaurav

 

 

Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    Check your RangeStart and RangeEnd filter. Only one of these parameters can be inclusive, the other must be exclusive

     

    RangeStart <= [partition date] < RangeEnd

5 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Check your RangeStart and RangeEnd filter. Only one of these parameters can be inclusive, the other must be exclusive

     

    RangeStart <= [partition date] < RangeEnd

    • TusharGaurav's avatar
      TusharGaurav
      Helper III
      2 years ago

      Thanks Ibendlin,

      I was actually RangeStart <= [partition date] <=RangeEnd, which I modified as per your suggestion.

      The dataset refreshed post the changes.

    • Praveen_Rangu's avatar
      Praveen_Rangu
      Frequent Visitor
      2 years ago

      even after doing that, 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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi TusharGaurav ,

     

    Thanks to lbendlin  for the reply, please allow me to provide another insight:

     

    1.Power BI sometimes automatically creates relationships between queries used to drive data in reports. you can:


    • Enter model view
    • Verify that relationships are listed
    • Evaluate the "from" and "to" relationships listed as active
    • Remove any invalid From and To relationships between separate data sets

     

    2.Power BI automatically trims trailing spaces, which may cause visually identical values to be viewed differently in the source database, please check and handle this situation in the database.

     

    3. Here are some solutions similar to your problem, I hope they can be helpful to you.
    Solved: Get "not allowed for columns on the one side of a ... - Microsoft Fabric Community
    Solved: Getting "not allowed for columns on the one side o... - Microsoft Fabric Community

     

    If your Current Period does not refer to this, please clarify in a follow-up reply.

     

    Best Regards,

    Clara Gong

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.