Exam PL-100 topic 5 question 13 discussion

DRAG DROP -
A company has the following divisions: wholesale and retail.
The manufacturer wants to create a single Power BI report to allow users to view data from a Microsoft SQL Server database.
You need to ensure that each user sees data only for the team to which the user is assigned.
How should you secure the report?
To answer, drag the appropriate options to the correct action. Each option may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.
Select and Place:

Suggested Answer:
Box 1: 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.
2. From the Modeling tab, select Manage Roles.
3. From the Manage roles window, select Create.
4. Etc.

Box 2: Power BI Service -
After you save your report in Power BI Report Server, you manage security and add or remove members on the server.
1. In Power BI Desktop, save the report to Power BI Report Server. You need to use the version of Power BI Desktop for Power BI Report Server.
2. In Power BI Report Service, select the ellipsis (ג€¦) next to the report.
3. Select Manage > Row-level security.

On the Row-level security page, you add members to a role you created in Power BI Desktop.
Reference:
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls