Forum Discussion
Data Model Feedback
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao
CB13 ,
Power bi data model doesn't allow ambiguous reference or circular reference. Could you please share the table structure and relatioship for further analysis?
Regards,
Jimmy Tao
v-yuta-msft Hi Jimmy,
The picture in my original post has a fake sample of the data. Here is a little more information about my current data model and the ambiguous reference in the picture below:
I unfortunately can't post a picture of the real example (this is a far simplified example).
If you're using the final example it should work well if you're using a double crossfilter direction in your relationships between the facts tables.
The other option is the merge all three tables together in the query editor.
/ JHi,
The final example is what I am currently using - but it doesn't allow me to link on Owner ID directly to the Visit and Test tables. Since the owner's vary this is important:
It feels like I may have to create 3 "copies" of the owner table, 1 to join to each, but this feels wasteful, especially since this is a simplified example and in reality I will likely have several more tables that need this same information.
I'm not sure what you mean by join the tables together in the data model. Wouldn't this then create a lot of additional data fields with repeated data - meaning that all of the Visit data would be repeated at the Item level, over and over again? This also feels ineffecient?
