Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 7 question 3 discussion

Actual exam question from Microsoft's PL-300

Question #: 3
Topic #: 7

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:

Show Suggested Answer

Suggested Answer:

Step 1: From BI Desktop, create four roles
You can define roles and rules within Power BI Desktop.
Step 2: From BI Desktop, add a Table Filter DAX Expression to the roles.
To define security roles, follow these steps.
1. From the Modeling tab, select Manage Roles.
2. Select Manage Roles
3. From the Manage roles window, select Create.
4. Select Create
5. Under Roles, provide a name for the role.
6. Under Tables, select the table to which you want to apply a DAX rule.
7. 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ג€.
After you've created the DAX expression, select the checkmark above the expression box to validate the expression.
8. Select Save.
Step 3: 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.
Step 4: From BI Desktop, publish the dataset to powerbi.com
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

by Manikom at Sept. 9, 2022, 11:52 a.m.

Comments

Submit Cancel

fdsdfgxcvbdsfhshfg

Highly Voted 2 years, 2 months ago

1) Create four roles 2) add DAX filters 3) publish 4) add role members Contributor role give analysts a possibility to save reports to a workspace, which is not permitted by requirements

upvoted 119 times

EMMALEEEEEEEEE

2 years, 1 month ago

'Analysts must NOT be able to share' so the role could be Contributor. Member can share. l would go : 1) Create four roles 2) add DAX filters 3) publish 4) assign the Contributor role

upvoted 9 times

AdrianBalescu

11 months, 4 weeks ago

1) Create four roles 2) add DAX filters 3) publish 4) add role members

upvoted 5 times

...

YokoSumiGaeshi

2 years ago

If you assign the Contributor role to a user, the RLS will be overriden and the user will see all the data. "Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. If you want RLS to apply to people in a workspace, you can only assign them the Viewer role." https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls

upvoted 17 times

...

Hoeishetmogelijk

1 year, 12 months ago

I understand the way you think, I made the same error. This question is very misleading. It doesn't say "assign the Member Role", but "add the role members to the role". So this is not about a Workspace Role, but about a Row Level Security role!

upvoted 18 times

...

Manikom

Highly Voted 2 years, 2 months ago

'From powerbi.com, add role members to the roles' this should be last action. You need to publish the dataset first to have it available to PowerBI service

upvoted 14 times

...

MoneyStacking

Most Recent 7 months ago

Passed with 917/1000 Question and answers were exactly the same but different order with the options! Answer given: - From Power BI Desktop, create four roles - From Power BI Desktop, add a Table Filter DAX Expression to the roles - From Power BI Desktop, publish the dataset to powerbi.com - From powerbi.com, add role members to the roles

upvoted 3 times

...

DataEngDP

8 months ago

In the exam 6/04/2025

upvoted 3 times

...

DataEngDP

9 months, 1 week ago

Why four roles?

upvoted 1 times

JudT

7 months, 3 weeks ago

Contoso holds quarterly board meetings for which financial analysts manually prepare Microsoft Excel reports, including balance sheets and profit and loss statements for each of the company's four business units.

upvoted 1 times

...

Suraj97

1 year ago

"Analysts must be able to access all balance sheet and product catalog data. Analysts must be able to access only the profit and loss data of their respective business unit. Analysts must be able to create new reports from the dataset that contains the profit and loss data, but the reports built by the analysts must NOT be included in the quarterly reports for the board. Analysts must NOT be able to share the quarterly reports with anyone. Analysts must NOT be able to make new reports by using the balance sheet data." why four roles, please explain and how report building option and denial to share report option possible through RLS. Should we just create just one role since only business unit analysts are involved here

upvoted 2 times

JudT

7 months, 3 weeks ago

upvoted 1 times

...

MEG_Florida

1 year, 4 months ago

1. In Power BI Desktop, Create 4 roles. 2. In Power BI Desktop, Add a table filter DAX expression. 3. In Power BI Desktop, Publish dataset. 4. In Power BI Service, Add roles members to roles. Credit to UlyUkr whom I copied from so I didnt need to type this lol but its correct

upvoted 1 times

...

UlyUkr

1 year, 6 months ago

1. In Power BI Desktop, Create 4 roles. 2. In Power BI Desktop, Add a table filter DAX expression. 3. In Power BI Desktop, Publish dataset. 4. In Power BI Service, Add roles members to roles.

upvoted 3 times

...