Phantom duplicate value error

Any topic that doesn't fit in elsewhere
Posts: 1
Joined: Thu Jul 06, 2017 8:08 pm

Phantom duplicate value error

Postby joldavidson » Thu Jul 06, 2017 8:12 pm

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.

Posts: 1120
Joined: Sun May 04, 2014 4:01 pm
Location: Sydney, Australia

Re: Phantom duplicate value error

Postby MattAllington » Thu Jul 06, 2017 8:55 pm

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

Return to “General”

Who is online

Users browsing this forum: No registered users and 3 guests