You need to ensure that each group of employees can see only data that pertains to their group. What should you do?

November 13, 2021 by Admin

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?

  • Create and assign field security profiles.
  • Create and assign Common Data Service security roles.
  • Create and assign roles by using row-level security.
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.

Leave a Reply