Which of the following is a valid step to hide a column from a security role in Tabular Editor?

Prepare for the Fabric Analytics Engineer Associate Test with comprehensive materials. Explore flashcards, multiple choice questions, and detailed explanations. Get ready for your success!

Multiple Choice

Which of the following is a valid step to hide a column from a security role in Tabular Editor?

Explanation:
Hiding a column from clients is done by marking it as Hidden. In Tabular Editor, this is as simple as selecting the column and setting Hidden to True. When a column is hidden, it won’t appear in any client experiences (Power BI, Excel, etc.), so it won’t be visible to anyone who accesses the model through security roles. This makes it a straightforward and supported way to reduce the data surface exposed to users. If you need more granular control for specific roles, you would use object-level security to restrict access on that column for particular roles, but the Hidden flag provides a quick, broad suppression of visibility. Deleting the column would remove it from the model entirely, which is usually undesirable; setting object-level security to Default doesn’t hide it; and simply creating a new role doesn’t affect visibility of the column.

Hiding a column from clients is done by marking it as Hidden. In Tabular Editor, this is as simple as selecting the column and setting Hidden to True. When a column is hidden, it won’t appear in any client experiences (Power BI, Excel, etc.), so it won’t be visible to anyone who accesses the model through security roles. This makes it a straightforward and supported way to reduce the data surface exposed to users.

If you need more granular control for specific roles, you would use object-level security to restrict access on that column for particular roles, but the Hidden flag provides a quick, broad suppression of visibility.

Deleting the column would remove it from the model entirely, which is usually undesirable; setting object-level security to Default doesn’t hide it; and simply creating a new role doesn’t affect visibility of the column.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy