PL-300 · Question #448
You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements: - The model must contain a table named Orders that has one row per order. Each row will…
The correct answer is A. an Orders query that has a filter on CustomerID D. a Customers query that has a single column containing a list of customer IDs E. a parameter for CustomerID that uses a query to populate the suggested values. To create a dynamic Power BI model where orders are filtered by a user-selected CustomerID from an OData source, you must define an Orders query filtered by a parameter, a parameter for CustomerID populated by a query, and a Customers query providing the list of Customer IDs.
Question
You need to create a semantic model in Power BI Desktop. The solution must meet the following requirements:
- The model must contain a table named Orders that has one row per
order. Each row will contain the total amount per order.
- The orders must be filtered to the selected CustomerID value.
- Users must select the CustomerID value from a list.
- The list of customers must come from an OData source.
Which three objects should you create in Power Query Editor? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
Options
- Aan Orders query that has a filter on CustomerID
- Ba Customers query that has a filter on CustomerID
- Can Orders query that has a single column containing a list of customers
- Da Customers query that has a single column containing a list of customer IDs
- Ea parameter for CustomerID that uses a query to populate the suggested values
- Fa parameter for CustomerID that uses manually entered values to populate the suggested values
How the community answered
(28 responses)- A79% (22)
- B11% (3)
- C7% (2)
- F4% (1)
Why each option
To create a dynamic Power BI model where orders are filtered by a user-selected CustomerID from an OData source, you must define an Orders query filtered by a parameter, a parameter for CustomerID populated by a query, and a Customers query providing the list of Customer IDs.
An Orders query that has a filter on CustomerID is essential to retrieve only the relevant orders based on the user's selection, with this filter typically referencing the CustomerID parameter.
A Customers query that has a filter on CustomerID is incorrect because the Customers query needs to provide *all* customer IDs for selection, not a filtered subset.
An Orders query that has a single column containing a list of customers is not the purpose of the Orders table, which should contain order details including the total amount per order, potentially filtered by customer.
A Customers query that has a single column containing a list of customer IDs is necessary to populate the dropdown list for users to select from, ensuring the list comes from the OData source as required.
A parameter for CustomerID that uses a query to populate the suggested values allows the user to select a CustomerID from a dynamic list (provided by the Customers query) and then pass that selection to filter the Orders query.
A parameter for CustomerID that uses manually entered values would not meet the requirement that the list of customers must come from an OData source.
Concept tested: Power Query parameters for dynamic filtering
Source: https://learn.microsoft.com/en-us/power-query/power-query-parameters#create-a-query-parameter
Community Discussion
No community discussion yet for this question.