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…

The correct answer is C. Create and assign roles by using row-level security. 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…

Manage environments

Question

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?

Options

ACreate and assign file security profiles.
BCreate and assign Common Data Service security roles.
CCreate and assign roles by using row-level security.

How the community answered

(35 responses)

A
9% (3)
B
20% (7)
C
71% (25)

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. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls

Topics

#Power BI#Row-level security (RLS)#Data security#Data filtering

Community Discussion

No community discussion yet for this question.

Full PL-200 Practice