I am trying to establish a relationship between tables in PowerPivot and keep receiving the same error about there being duplicate values in both columns, in spit of the fact that one of the columns does not have any duplicate values. The error message is as follows:
============================
Error Message:
============================
The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.
============================
Call Stack:
============================
at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(DataModelingColumn sourceColumn, DataModelingColumn relatedColumn)
at Microsoft.AnalysisServices.Common.RelationshipController.CreateRelationship(String fkTableName, String fkColumnName, String pkTableName, String pkColumnName)
at Microsoft.AnalysisServices.Common.SandboxEditor.erDiagram_CreateRelationshipCallBack(Object sender, ERDiagramCreateRelationshipEventArgs e)
at Microsoft.AnalysisServices.Common.ERDiagram.ERDiagramActionCreateRelationship.Do(IDiagramActionInstance actionInstance)
Any help would be greatly appreciated.
Phantom duplicate value error
-
- Posts: 1067
- Joined: Sun May 04, 2014 4:01 pm
- Location: Sydney, Australia
Re: Phantom duplicate value error
Are there any blanks? Blanks can cause this error too
Matt Allington is Self Service BI Consultant, Trainer and Author of the Book "Supercharge Power BI".
Power BI Training
Power BI Training
Who is online
Users browsing this forum: No registered users and 1 guest