Security Roles

[gayathrispark]

You need to provide a solution to provide the sales managers with the required access.
What should you include in the solution?
A . Create a security role that has a table filter on the Sales_Manager table where username = UserName()
B . Create a security role that has a table filter on the Region_Manager table where sales_manager_id = UserPrincipalName().
C . Create a security role that has a table filter on the Sales_Manager table where name = UserName().
D . Create a security role that has a table filter on the Sales_Manager table where username = sales_manager_id.

[v-yiruan-msft · Accepted solution]

Hi @gayathrispark ,

You can refer to the following links to define and configure RLS in your report so that different levels of users can view different data...

Restrict data access with row-level security (RLS) for Power BI Desktop

Dynamic Row Level Security with Manager Level Access in Power BI

---

---

Set Different Levels of Access on the Same Dataset in Power BI using Row Level Security

Best Regards