cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rpe
Frequent Visitor

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?

 

 

1 ACCEPTED SOLUTION
v-sihou-msft
Microsoft
Microsoft

@rpe

 

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,

View solution in original post

2 REPLIES 2
v-sihou-msft
Microsoft
Microsoft

@rpe

 

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,

View solution in original post

rpe
Frequent Visitor

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. 

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors