Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
trying to a link a many to one relationship in a tabular model RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I am trying to link a many to one relationship in a tabular model and keep getting the error of 'The relationship cannot be created because each column contains duplicate values. Select at least one column that contains only unique values.'  The fields have unique values.  We also tried the related function to and that didn't work.  Here is a screen shot of my error.

    Monday, August 24, 2015 10:25 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi jackcrawfish,

    Actually you know that this forum is to discuss:

    Visual Studio WPF/SL Designer, Visual Studio Guidance Automation Toolkit, Developer Documentation and Help System, and Visual Studio Editor.

    Sorry for that I didn't find the information which is related to the VS IDE, it seems that it is not the VS IDE issue.

    I also did some research about the error message and the windows in your screen shot.

    Just to make this issue clearly, whether it is related to the SQL Server PowerPivot like this case?

    Reference:

    https://msdn.microsoft.com/en-us/library/gg413432%28v=sql.110%29.aspx?f=255&MSPPError=-2147217396

    If it is related to the SQL Server, you'd better post this issue to the SQL Server forum.

    If not, please let me know more information about this issue, maybe I could provide a more appropriate forum for you.

    Best Regards,

    Jack

    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, August 26, 2015 7:06 AM
  • Question
    Sign in to vote
    1
    Sign in to vote

    Hello,

    The SQL Server forums are over here:

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/home

    Karl

    When you see answers and helpful posts, please click Vote As Helpful, Propose As Answer, and/or Mark As Answer.
    My Blog: Unlock PowerShell
    My Book: Windows PowerShell 2.0 Bible
    My E-mail: -join('6D73646E5F6B61726C406F75746C6F6F6B2E636F6D'-split'(?<=\G.{2})'|%{if($_){[char][int]"0x$_"}})

    Monday, September 14, 2015 2:20 PM