DRAG DROP - You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select...

Questions › Category: PL-300 › DRAG DROP – You plan to create a report that will display sales data from the last year for multiple regions. You need to restrict access to individual rows of the data on a per region-basis by using roles. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. Select…

0 Vote Up Vote Down

Admin Staff asked 4 months ago

DRAG DROP -
You plan to create a report that will display sales data from the last year for multiple regions.
You need to restrict access to individual rows of the data on a per region-basis by using roles.
Which four actions should you perform in sequence? 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:

Suggested Answer:

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 (Step 1)
2. From the Modeling tab, select Manage Roles.
3. From the Manage roles window, select Create. (Step 2)
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)
7. After you've created the DAX expression, select the checkmark above the expression box to validate the expression.
8. Select Save.
Step 3: Assign Users to the role.
You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service.
After you've created your roles, test the results of the roles within Power BI Desktop.
Step 4: Publish the report.
Now that you're done validating the roles in Power BI Desktop, go ahead and publish your report to the Power BI service.
Reference:
https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

This question is in PL-300 Microsoft Power BI Data Analyst Exam
For getting Microsoft Certified: Power BI Data Analyst Associate Certificate

Disclaimers:
The website is not related to, affiliated with, endorsed or authorized by Microsoft.
The website does not contain actual questions and answers from Microsoft's Certification Exams.
Trademarks, certification & product names are used for reference only and belong to Microsoft.