Forum Discussion
Semantic Model load error Name contains a duplicate value
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:
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.
Ill try this one first.
The relationship is definitely Dim Project Prokect Key (1) to Project Key fact (M) so no issues there but I have removed the relationship to try again.
And its still erroring on the issue
then i sarted to think. I have a lot of transformation and landing tables in there (Because I havent managed to use a staging area for this project, Never good I know.
So could it be a staging table linking.....And yep. Power BI had assigned a relationship to the landing table on name that i hadnt seen.
And that resolved it. I hadnt thought about all these hidden tables I have had to have in the model.
Thanks you
Note that you don't need to load staging tables to your model. Go to the query editor and uncheck Enable load for any staging tables you don't want to be a table in your semantic model.
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?
The staging tables that your fact and dimension tables depend upon will still be updated even if you don't load them.