Microsoft Fabric Analytics Engineer Associate DP-600
Get started today
Ultimate access to all questions.
You are designing a semantic model for a financial reporting application in Microsoft Fabric. The application requires that access to a specific financial measure, 'Net Profit', be restricted based on the user's role within the organization. The solution must ensure that only users with the 'Finance Manager' role can view the 'Net Profit' measure, while other roles should not see this measure in their reports. Additionally, the solution should minimize administrative overhead and not require the creation of multiple semantic models. Which of the following approaches BEST meets these requirements? (Choose one option.)
You are designing a semantic model for a financial reporting application in Microsoft Fabric. The application requires that access to a specific financial measure, 'Net Profit', be restricted based on the user's role within the organization. The solution must ensure that only users with the 'Finance Manager' role can view the 'Net Profit' measure, while other roles should not see this measure in their reports. Additionally, the solution should minimize administrative overhead and not require the creation of multiple semantic models. Which of the following approaches BEST meets these requirements? (Choose one option.)
Explanation:
Creating a hidden measure and configuring object-level security is the most efficient and effective approach to restrict access to a specific measure based on user roles. This method directly addresses the requirement by allowing only the 'Finance Manager' role to access the 'Net Profit' measure without the need for multiple semantic models or complex DAX expressions. Row-level security (RLS) is not suitable for object-level restrictions, and creating separate semantic models would increase administrative overhead. Using DAX to dynamically display the measure based on the user's role could work but is less straightforward and more prone to errors than using object-level security.