Notifications
Clear all
Topic starter
16/10/2022 12:33 pm
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.
Suggested Answer: A
Explanation:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/
Explanation:
https://powerbi.microsoft.com/en-us/blog/using-username-in-dax-with-row-level-security/