Forum Discussion

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity 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:

DebbieE's avatar
DebbieE
Icon for Community Champion rankCommunity Champion
2 years ago

I have never really understood this. I start with my landing tables that get refreshed. Then, I still want to refresh the staging tables because the staging tables then refresh the Dims and Facts. So dont I need to Load them so they populate dim and Fact? otherwise I wont be able to populate dim and fact with the latest refreshed data.

 

am I getting the logic wrong here? 

 

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

The staging tables that your fact and dimension tables depend upon will still be updated even if you don't load them.