Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Duplicate value does not allow me to progress with my data transformation.

Hi

I am trying to tarsform my data in Power BI but when I apply my chages it stops me with this message that one of my columns "contains a duplicate value '0' 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".

 

What options do I have to solve/bypass this and get on with my changes?

 

Thanks

Reza

 

 

 

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Unfortunately not, but after that I redesigned my approach and bypassed the issue

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi JadhavVarsha_13

    As you can see the table has no relathionship with any other table!

     

  • Pizamka0's avatar
    Pizamka0
    Frequent Visitor
    2 years ago

    In PowerQuery view go to 'Add Column', click on 'Index Column'. Close PowerQuery and go to the modeling view. Click on the table and in properties set the Index Column you have just created as Key column