Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
2 years ago
Solved

Semantic Model load error Name contains a duplicate value

Power Query editor all the data is rfreshing fine.   I load into Power BI and get an error   Column Name in Table Dim Project contains a duplicate value of 'Name 1' and this is not allowed for c...
Need Help
  • MFelix's avatar
    MFelix
    2 years ago

    Hi DebbieE ,

     

    Double check if the relationship was done by the correct column, sometimes when dragging and dropping I select the incorrect column by mistake.

     

    A waork around is to remove the relationship, make the Power Query changes and then redo the relationship.

  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    From the error, it sounds like you're using Name as a relationship column. Double-check that there aren't any relationships on Name.

     

    If that's not the case, I suppose it's still possible that the Name column got designated as a key column at some point. You can check and set that property with Tabular Editor but I'm not sure that's possible directly in Power BI Desktop.

     

    Properties panel in TE3:

MFelix's avatar
MFelix
Super User
2 years ago

Hi DebbieE ,

 

Double check if the relationship was done by the correct column, sometimes when dragging and dropping I select the incorrect column by mistake.

 

A waork around is to remove the relationship, make the Power Query changes and then redo the relationship.