Question

You have configured a row-level security (RLS) role named 'RegionalManager' on a semantic model in Power BI Desktop. The role uses a DAX filter on the Sales table so that managers only see rows for their assigned region. Before publishing to the Power BI service, you want to confirm that the filter behaves correctly and returns only the expected regional data. What should you do in Power BI Desktop?

Accepted Answer

Use the 'View as' feature on the Modeling tab and select the 'RegionalManager' role to preview the report as a member of that role.

Answer

Publish the model to the service and add a test user to the role in the semantic model security settings.

Answer

Open the 'Manage roles' dialog and re-save the DAX filter expression to force validation.

Answer

Assign yourself to the 'RegionalManager' role in workspace settings and refresh the report.