If none of the tables selected for the relationship has unique values, you'll see the following error: One of the columns must have unique values. For more information, see Understanding additional options. However, you can change these settings if necessary. Select the other column you want to use, and then select OK.īy default, Power BI Desktop automatically configures the options Cardinality (direction), Cross filter direction, and Make this relationship active for your new relationship. In the second table drop-down list, select the other table you want in the relationship. Select the column you want to use in the relationship. In the Create relationship dialog box, in the first table drop-down list, select a table. On the Modeling tab, select Manage relationships > New. On the Modeling tab, select Manage relationships > Autodetect. However, you can still use the Manage relationships dialog box to manually create or edit relationships. If Power BI Desktop can't determine with a high level of confidence there's a match, it doesn't create the relationship. If there are, those relationships are created automatically. Power BI Desktop looks at column names in the tables you're querying to determine if there are any potential relationships. The relationship options Cardinality, Cross filter direction, and Make this relationship active are automatically set. 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.

Either way, it’s important to understand relationships in Power BI Desktop and how to create and edit them. However, sometimes you might have to create relationships yourself, or need to make changes to a relationship. In most cases you won’t have to do anything.

Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports. When you have multiple tables, chances are you'll do some analysis using data from all those tables.

How to create pie chart in excel 1007