When you create a new visual in Power BI and you use fields from more than one table, how does the tool know how those fields are related? Well, Power BI is a powerful tool and one of the functions it can do (and is selected to do so by default) is to create the relationships between queries when they are brought into the data set so that the tables will relate as expected. This is normally quite helpful but for a number of reasons it doesn't always do it as expected, or it doesn't do it at all.

This interactive, hands-on training, will include a sample file to use while how relationships work in Power BI.

This training will include at least the following aspects of relationships in Power BI:

• Data Types

• The model view

○ Standard layouts (Auto Layout)

○ Custom layouts

○ Properties

• Relationship Types

○ One to One

○ One to Many

○ Many to One

○ Many to Many

• Cross Filter Direction

○ Single

○ Both

• Assuming referential integrity

• Apply the security filter

• Creating your own key

○ Considerations

○ How to create key(s)

Requirements:

Power BI Desktop

Internet connectivity

Be able to join a Microsoft Teams session

*It is strongly recommended that participants have at least 2 monitors.

Class Length: 2.5 Hours

Power BI Data Keys and Relationships

Follow this organizer to stay informed on future events

Events you might like

The Philosophy of Love and RelationshipsThe Philosophy of Love and Relationships

ADHD and RelationshipsADHD and Relationships

ADHD and RelationshipsADHD and Relationships

Autism and RelationshipsAutism and Relationships

Counselling for Couples and RelationshipsCounselling for Couples and Relationships

The Philosophy of Love and Relationships

ADHD and Relationships

ADHD and Relationships

Autism and Relationships

Counselling for Couples and Relationships