Home » Microsoft » DA-100 v.2 » Case study
DRAG DROP
Once the profit and loss dataset is created, which four actions should you perform in sequence to ensure that the business unit analysts see the appropriate profit and loss data? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.
Select and Place:
Correct Answer:
Explanation/Reference:
Explanation:
Scenario: The analysts responsible for each business unit must see all the data the board sees, except the profit and loss data, which must be restricted to only their business unit’s data. The analysts must be able to build new reports from the dataset that contains the profit and loss data, but any reports that the analysts build must not be included in the quarterly reports for the board. The analysts must not be able to share the quarterly reports with anyone.
Define roles and rules in Power BI Desktop
You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions.
To define security roles, follow these steps.
1. Import data into your Power BI Desktop report, or configure a DirectQuery connection.
(step 1: From Power BI Desktop, publish the dataset to powerbi.com)
2. From the Modeling tab, select Manage Roles.
3. From the Manage roles window, select Create.
(Step 2: From Power BI Desktop, create four roles.)
4. Under Roles, provide a name for the role.
5. Under Tables, select the table to which you want to apply a DAX rule.
6. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.
(Step 3: From Power BI Desktop, add Table Filter DAX Expression to the roles.)
7. After you’ve created the DAX expression, select the checkmark above the expression box to validate the expression.
8. Select Save.
Step 4: From powerbi.com, add role members to the roles.
You can’t assign users to a role within Power BI Desktop. You assign them in the Power BI service.
Reference:
https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls