Live connect + One-to-many

[Anonymous]

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?

[v-sihou-msft · Accepted solution]

@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]

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.