What should you include in the solution?

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.

View Answer

Answer: B

Explanation:

Scenario: The region_id column can be managed by only one sales manager.

You can use Username() or userprincipalname() in DAX with Row-Level Security.

Within Power BI Desktop, username() will return a user in the format of DOMAINUser and userprincipalname() will return a user in the format of user@contoso.com.

Reference: https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls