Forum Discussion

MartinSvava77's avatar
MartinSvava77
New Member
5 years ago

Help with Power bi service duplicate value

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 ?

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    • MartinSvava77's avatar
      MartinSvava77
      New Member
      5 years ago

      Anonymous 

      There are no blank values in that colum. 

       

      I have deaktivatet  automatic realtionship in that pbix 

       

      And still I get the same.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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