Create and manage relationships in Power BI Desktop

[bitheerani319]

When you import multiple tables, you'll likely perform some analysis using data from all of those tables. Relationships between those tables are necessary to accurately calculate results and display the bolivia mobile database information in your reports. Power BI Desktop makes it easy to create these relationships. In fact, in most cases, you won't need to do anything—the auto-detection feature will do it all for you. However, sometimes you may need to create relationships yourself or make changes to a relationship. Either way, it's important to understand relationships in Power BI Desktop and how to create and edit them.

Automatically detect while charging
If you query two or more tables at the same time, when the data is loaded, Power BI Desktop attempts to find and create relationships for you. The relationship options Cardinality , Cross filter direction , and Make this relationship active are set automatically. Power BI Desktop looks at column names in the tables you're querying to determine if there are any potential relationships. If there are, those relationships are created automatically. If Power BI Desktop can't determine with a high level of confidence that there is a match, it doesn't create the relationship. However, you can still use the Manage relationships dialog box to manually create or edit relationships.

Create a relationship with auto-discovery
On the Home tab , select Manage Relationships > Auto-Detect .

Create a relationship with auto-discovery

Create a relationship manually
On the Home tab , select Manage Relationships > New .

In the Create Relation dialog box , in the first Table drop-down list, select a table. Select the column that you want to use in the relationship.

In the second Table drop-down list, select the other table that you want to have in the relationship. Select the other column that you want to use, and then choose OK .

Create a manual relationship

By default, Power BI Desktop automatically configures the Cardinality (direction), Cross filter direction , and Make this relationship active options for your new relationship. However, you can change these settings if needed. For more information, see Understanding additional options .

If none of the tables selected for the relationship have unique values, you will see the following error: One of the columns must have unique values . At least one table in a relationship must have a distinct and unique list of key values, which is a common requirement for all relational database technologies.