ExamGecko
Question list
Search
Search

List of questions

Search

Related questions











Question 76 - PL-200 discussion

Report
Export

You create a report by using Power BI Desktop and a Power BI dataset that is connected to Azure SQL Database. Multiple groups of employees will use the report.

You need to ensure that each group of employees can see only data that pertains to their group.

What should you do?

A.

Create and assign field security profiles.

Answers
A.

Create and assign field security profiles.

B.

Create and assign Common Data Service security roles.

Answers
B.

Create and assign Common Data Service security roles.

C.

Create and assign roles by using row-level security.

Answers
C.

Create and assign roles by using row-level security.

Suggested answer: C

Explanation:

You can use row-level security (RLS) with Power BI Desktop to restrict data access for given users. Filters restrict data at the row level. You can define filters within roles.

You can now configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server.

Incorrect Answers:

A: You can restrict access to a field by creating a field security profile. After you create the profile, you assign users and or teams to that profile, and set up specific read, create, or write permissions for the field.

Reference:

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls

asked 05/10/2024
Kanik Sachdeva
37 questions
User
Your answer:
0 comments
Sorted by

Leave a comment first