exam questions

Exam PL-300 All Questions

View all questions & answers for the PL-300 exam

Exam PL-300 topic 2 question 11 discussion

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

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:

Show Suggested Answer Hide Answer
Suggested Answer:

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
OGESSIUSER
Highly Voted 2 years, 7 months ago
Import data create the roles on power bi Publish the report Assign Users to the role.
upvoted 277 times
Fillali
2 years, 3 months ago
Yes, I tested it ! You have to choose a dataset before assigning roles to users. (Path : powerbi.com > dataset > more options > security)
upvoted 3 times
...
bdub1976
1 year, 4 months ago
Import, Create, Publish, Assign Yes, https://learn.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method
upvoted 8 times
...
louisaok
2 years, 4 months ago
Yes, correct. If publish first and then create a role, then all users will see the info, which against the requirement.
upvoted 7 times
Ashokku22
1 year, 9 months ago
you have to assign roles after publishing as we are already created in 2nd step in Power BI Desktop
upvoted 2 times
...
...
vanessa1923
2 years, 2 months ago
"You can't assign users to a role within Power BI Desktop. You assign them in the Power BI service. You can enable dynamic security within Power BI Desktop by making use of the username() or userprincipalname() DAX functions and having the proper relationships configured." from https://learn.microsoft.com/en-us/power-bi/enterprise/service-admin-rls OGESSIUSER is correct
upvoted 17 times
...
...
RickyAnd
Highly Voted 2 years, 7 months ago
Import data create the roles on power bi Publish the report Assign Users to the role. https://docs.microsoft.com/en-us/training/modules/row-level-security-power-bi/2-static-method
upvoted 30 times
...
Jasmine121
Most Recent 2 months ago
Wrong Answer The last two options should be different order
upvoted 1 times
...
ee0625a
2 months, 2 weeks ago
Import the data, Create the roles on Power BI Desktop, Publish the report (You must publish the report and its dataset to Power BI Service before you can assign users to the roles in the same Power BI Service); Assign users to t he role.
upvoted 2 times
...
hebertorosillo
2 months, 3 weeks ago
Import the data to Power BI Desktop create a role definition Publish the report Assign user to the role.
upvoted 2 times
...
627628c
3 months, 1 week ago
This was on the exam 1/17/24
upvoted 1 times
...
LuluSkyy
6 months, 3 weeks ago
It's Import - Create - Publish - Assign
upvoted 3 times
...
rcaliandro
8 months, 1 week ago
1 - Import the data to PBI Desktop 2 - Create a role definition 3 - Assign users to the role 4 - Publish the report
upvoted 2 times
...
DataEngDP
1 year, 1 month ago
Import-->Create-->Publish-->Assign
upvoted 3 times
...
Dani_eL
1 year, 2 months ago
the context is unclear; proposed solution can be valid: If you have a fact sales tables having a country Id joined on a dim country table which itself joins a dim persons table containing the full email. You can create your role and add the dax exp person=username() then Apply security filter in both directions checkbox Finally test the report's behavior with "view as" (none, other, rule) when satisfied, publish the report
upvoted 1 times
...
JohnChung
1 year, 3 months ago
Agree with Import > Create > Publish > Assign Since roles should be assigned in PowerBI Service, Publish must done before Assign
upvoted 2 times
...
MayurV19
1 year, 4 months ago
Correct. 1. Import the data to Power BI Desktop 2. Create a role definition 3. Publish the report 4. Assign users to the role (in Power BI Service)
upvoted 1 times
...
Male777
1 year, 4 months ago
I think Sequence is wrong we will Assign Users to the role only after we "Publish the Report"
upvoted 2 times
...
LeT2
1 year, 6 months ago
Agree with you
upvoted 1 times
...
itenginerd
1 year, 7 months ago
A flavor of this was on the test today.
upvoted 2 times
...
Igetmyrole
1 year, 7 months ago
First Step: Import the data to Power BI Desktop Second Step: Create a role definition. Third Step: Assign Users to the role. Fourth Step: Add a filter to the report.
upvoted 2 times
...
linkide
1 year, 9 months ago
This answer is simply wrong. I won't be using this site anymore.
upvoted 5 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
Loading ...
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago