ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 94 - PL-100 discussion

Report
Export

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.


Question 94
Correct answer: Question 94

Explanation:

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

asked 05/10/2024
Kellen Winters
40 questions
User
0 comments
Sorted by

Leave a comment first