Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
UsePowerBI
Post Prodigy
Post Prodigy

Tutorial for data model relationships?

Hello

 

I have several tables and I want to use various columns from each of these tables. I build relationships based on the fields that contain common values.

 

However, when I start dropping fields in a table visual, the values are not displayed correctly. Particularly, some values are missing when they shouldn't.

 

Can you provide some guidance on how to build relationships to achieve what I want?

For example, what relationship parameters to use?

 

Also there is something that seems to be a major annoyance of PowerBI.

 

After I have built the data relationships, when I bring together two columns from different tables in a table visual, all the values are shown as expected. But when I put other columns from other tables inbetween, it seems the relationships are broken. Any advice on that please?

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi  @UsePowerBI 

For the relationship in power bi model, you could refer to this document:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-lili6-msft
Community Support
Community Support

hi  @UsePowerBI 

For the relationship in power bi model, you could refer to this document:

https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationships

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.