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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.