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

Explanation:

https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/