Question

You maintain a Power BI semantic model in Microsoft Fabric that contains a Payroll table with sensitive compensation columns. Executives must see the Payroll table in reports, but a group of regional analysts must not even be aware the table exists—it should be completely hidden from their field list and any queries. Row-level security is already configured for other tables. What should you implement to meet the requirement for the analysts?

Accepted Answer

Object-level security (OLS) that restricts the Payroll table for the analysts' role, defined using an external tool such as Tabular Editor

Answer

Column-level security in the underlying warehouse to deny SELECT on the Payroll columns

Answer

A row-level security (RLS) DAX filter that returns FALSE() for the analysts' role on the Payroll table

Answer

Apply a Highly Confidential sensitivity label to the Payroll table so analysts cannot view it