Help with Power bi service duplicate value

[MartinSvava77]

Hey

I get this error in Power bi service 

Column 'Fragtbrev' in Table 'FactColli' contains a duplicate value '<pii>11527774</pii>' 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.

First that table FactColli only has a one to one relation with one other table.

Also I Removed Duplicates in Power query

Any ideas ?

[Anonymous]

Hi @MartinSvava77 ,

It's sound everything is correct according to your discription. Could you please share the PBIX if you don't have any Confidential Information?

In additon, have you applied the change after removing duplicate rows in Query Editor?

Best Regards,

Jay

[Anonymous]

@MartinSvava77  did u check if the table has blank values ? or automatic realtionship created within the model ??

[MartinSvava77]

@Anonymous 

There are no blank values in that colum. 

I have deaktivatet  automatic realtionship in that pbix 

And still I get the same.