Create Relationship In POWER BI

  • When we import multiple tables for analysis then the relationship between tables is necessary for the accurate calculation result.
  • Relationship in Power BI is used to define the connections or the relation between two or more tables.

CREATE RELATIONSHIP

GET DATA
SQL SERVER DATABASE
NAVIGATOR

AUTODETECT RELATIONSHIP

  • Power BI determines the column names in the table. If there are any potential relationships then only relationships are created.
  • If Power BI Desktop can’t determine a match then it doesn’t create any relationship.
  • However, we can use the Manage Relationships dialog box to manually create or edit relationships.
HOME TAB
  • Here In the Manage Relationship Window, we don’t find any relationships.
MANAGE RELATIONSHIP
  • After that Create Relationship window is open. Here we select the table in the drop-down list also we select related columns. Finally, click on the ok button.
  • The relationship options Cardinality, Cross filter direction and Make this relationship active are automatically set.

ADDITIONAL OPTIONS

Cardinality:-

  • One To One:- In a one to one relationship, the column in one table has only one instance of a particular value, and the other related table has only one instance of a particular value.
  • One To Many:- In a one to many relationships, the column in one table has only one instance of a particular value, and the other related table can have more than one instance of a value.
  • Many To Many:- We can establish a many-to-many relationship between composite tables, which removes requirements for unique values in tables.

Cross Filter Direction:-

  • Single:- The most common and default direction, which means filtering choices in connected tables work on the table where values are being aggregated.

Make This Relationship Active:-

CREATE RELATIONSHIP
MANAGE RELATIONSHIP
  • Model is used to display the relationship between two tables in a diagrammatical form which is also called the Entity-Relationship (ER)Diagram.
ONE TO MANY RELATIONSHIP

If you are new to Power BI start with the following must-watch video:-

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store