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.
Answer: A
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