ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam
Go to Exam

Exam PL-300 topic 7 question 3 discussion

Actual exam question from Microsoft's PL-300
Question #: 3
Topic #: 7
[All PL-300 Questions]

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 Hide 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

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
fdsdfgxcvbdsfhshfg
Highly Voted 1 year, 10 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 120 times
EMMALEEEEEEEEE
1 year, 9 months 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
Hoeishetmogelijk
1 year, 7 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
...
YokoSumiGaeshi
1 year, 7 months 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
...
AdrianBalescu
7 months ago
1) Create four roles 2) add DAX filters 3) publish 4) add role members
upvoted 5 times
...
...
...
Manikom
Highly Voted 1 year, 10 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 2 months, 1 week 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 4 times
...
DataEngDP
3 months ago
In the exam 6/04/2025
upvoted 4 times
...
DataEngDP
4 months, 2 weeks ago
Why four roles?
upvoted 1 times
JudT
3 months 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 2 times
...
...
Suraj97
7 months, 3 weeks 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
3 months 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
...
...
MEG_Florida
11 months, 2 weeks 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, 1 month 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
...
BabaJee
1 year, 6 months ago
Makes sense to publish first and then assign roles. 1) Create four roles 2) Add DAX filters 3) Publish 4) Add role members
upvoted 6 times
...
youssef_yt89
1 year, 6 months ago
1) Create four roles 2) Add DAX filters 3) Publish 4) Add role members
upvoted 6 times
...
lukelin08
1 year, 7 months ago
1) Create four roles 2) add DAX filters 3) publish 4) add role members
upvoted 5 times
...
Jay_98_11
1 year, 7 months ago
1. Publish 2. create role 3. add DAX filters 4. add members to roles
upvoted 5 times
iccent2
1 year, 6 months ago
This is wrong! The correct sequence is: 1) Create four roles 2) add DAX filters 3) publish 4) add role members
upvoted 6 times
...
zubairakram
1 year, 3 months ago
Correct answer
upvoted 2 times
...
Bin_Hashim
1 year, 7 months ago
Jay_98_11, need to re-check answer.
upvoted 1 times
...
...
Aksana
1 year, 9 months ago
I would go with this approach: https://vceguide.com/case-study-125/
upvoted 3 times
...
ecwang
1 year, 10 months ago
1) From Power BI Desktop publish 2) create four roles 3) add a Table filter DAX expression 4) From powerbi.com, add role members to the roles
upvoted 6 times
patthebadcat
1 year, 7 months ago
this is wrong
upvoted 6 times
...
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago