Microsoft Certified Power Platform Functional Consultant Associate · Free Practice Question Medium
Question 49
When you import multiple tables, chances are you'll do some analysis using data from all those tables. Relationships between those tables are necessary to accurately calculate results and display the correct information in your reports.
How do you get Power BI Desktop to find relationships in data after it has been imported?
-
A
Use the Performance Manager
-
B
Select the New Parameter button to map the relationship
-
C
Select Manage Relationships and then Autodetect
-
D
Open the Power Query Editor
Reveal correct answer
Correct answer: C
Explanation
You can use the Manage Relationships dialog to create or edit relationships.
Create a relationship with autodetect
On the Home tab, select Manage Relationships → Autodetect.
Create a relationship manually
On the Home tab, select Manage Relationships > New.
In the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship.
In the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then select OK.
By default, Power BI Desktop automatically configures the options Cardinality (direction), Cross filter direction, and Make this relationship active for your new relationship. However, you can change these settings if necessary. For more information, see Understanding additional options.
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. At least one table in a relationship must have a distinct, unique list of key values, which is a common requirement for all relational database technologies.
If you encounter that error, there are a couple of ways to fix the issue:
Use Remove Duplicates to create a column with unique values. The drawback to this approach is that you might lose information when duplicate rows are removed; often a key (row) is duplicated for good reason.
Add an intermediary table made of the list of distinct key values to the model, which will then be linked to both original columns in the relationship.
A. The Performance Manager in Power BI Desktop is not a feature specifically designed to help in finding relationships between tables. It is primarily used for monitoring and optimizing the performance of reports and dashboards, rather than managing data relationships.
B. Selecting the New Parameter button to map relationships in Power BI Desktop is not the correct method for automatically finding relationships in imported data. Parameters are typically used to store and manage values that can be referenced in queries or calculations, rather than establishing connections between tables.
C. Selecting Manage Relationships and then choosing Autodetect in Power BI Desktop allows the tool to automatically search for and create relationships between tables based on common fields or keys. This feature helps streamline the process of establishing connections between data tables for accurate analysis and reporting.
D. Opening the Power Query Editor in Power BI Desktop is primarily used for data transformation and shaping tasks, such as cleaning, filtering, and merging data. While relationships between tables can be managed within the Power Query Editor, it does not specifically help in automatically detecting and creating relationships between tables.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
