SSAS Tabular relationship behaving odd


  • I have 2 tables which I have in my tabular model and they have a 1 to many relationship.  I am working with appraiser data and the first table (AppraiserExpertise) has an appraiser ID and an expertise ID.  There can be multiple records in this table for an appraiser, as an appraiser can have more than one expertise.  The 2nd table (AppraiserExpertiseDescription) has the expertise ID and a description of what the expertise is.  I have created the relationship between the expertise IDs in the model, so to me it seems like we should be set to go.

    However, when I preview the data in Excel I find issues.  I pull in the AppraiserID from the AppraiserExpertise table and then pull in the description from the AppraiserExpertiseDescription table and I am ending up with a cartestian.  

    Any ideas on what I am missing here?

    Thanks in advance for the help.

    Thursday, September 26, 2013 5:16 PM