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

[ahooee]

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

[Pizamka0]

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

[ahooee]

Hi JadhavVarsha_13

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

[JadhavVarsha_13]

Hello @ahooee  try changing relation using model view 

[ahooee]

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