Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Live connect + One-to-many

I have two tables in a tabular-model; A DIM-table with a card-id field and a related table with tags for each card-id in the DIM-table. When I Import the data into Power BI and create the relationship there everything can be visualised just fine. However, we're switching to Live Connect only, so I have to define table relationships, measures and calculated columns in the tabular-model. When I do this and Live Connect to the model from Power BI, I get the two tables but they are not related as they should be. What am I doing wrong?

 

 

Need Help
  • v-sihou-msft's avatar
    v-sihou-msft
    10 years ago

    Anonymous

     

    I can't reproduced your issue. Those tables can be related properly in live connection to Tabular database. Please check if you process and deploy the tabular project after your define those relationships, measures and calculated columns. Also make sure you activate correct relationship between tables in your tabular model. 

     

    Regards,

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    10 years ago

    Anonymous

     

    I can't reproduced your issue. Those tables can be related properly in live connection to Tabular database. Please check if you process and deploy the tabular project after your define those relationships, measures and calculated columns. Also make sure you activate correct relationship between tables in your tabular model. 

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Thanks for the reply, Simon. I have done all that. Since no one has similar experiences, it's probably me, so I'll try again and close this thread.