Forum Discussion

CB13's avatar
CB13
Frequent Visitor
6 years ago
Solved

Data Model Feedback

Hi, I am sketching out my pass at a data model and have a question for the hive as I am relatively new to trying to figure out schemas, and I think my data is a bit of mix with transactions that hav...
Need Help
  • v-yuta-msft's avatar
    v-yuta-msft
    6 years ago

    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

v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

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

CB13's avatar
CB13
Frequent Visitor
6 years ago

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).