DP-600: Implementing Analytics Solutions Using Microsoft FabricDemo

By Microsoft · Question Mode

QuestionQ210

Implement and manage semantic models

You create a semantic model by using Microsoft Power BI Desktop. The model contains one security role named SalesRegionManager and the following tables:

  • Sales
  • SalesRegion
  • SalesAddress

You need to modify the model so that users assigned to the SalesRegionManager role cannot view the column named Address in SalesAddress.

Which three actions should you perform, in sequence?

Drag & Drop
Open the model in Power BI Desktop.
Open the model in Tabular Editor.
Select the Address column in SalesAddress.
Set the Hidden property to True.
Set Object Level Security to Default for SalesRegionManager.
Set Object Level Security to None for SalesRegionManager.
Explanation

Object-level security is role-specific and must deny the column for SalesRegionManager. In Tabular Editor, assigning Object Level Security to None for SalesAddress[Address] prevents members of that role from seeing or querying the column. The Hidden property is a presentation setting, not a security boundary.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!