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

  • Question

  • 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

  • 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
  • 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
    Moderator