Your company uses the new workspace experience in Power BI. In Power BI Desktop you create a role called EastRegion that filters the Sales table to Sales[Territory] = "East". After publishing the semantic model to a workspace, you add several users to the EastRegion role, but they are workspace Members. When these users open a report, they still see all territories. What should you do to ensure the role's filter is enforced?
Republish the semantic model after selecting "Apply security filters in both directions" for the relevant relationship.
Change the users' workspace role from Member to Viewer so RLS is applied when they view reports.
Disable the Build permission for the dataset in the workspace settings.
Publish the report as part of an app and assign the EastRegion role at the app level.
In the new workspace experience, row-level security is only enforced for users who have the Viewer role in the workspace. Admins, Members, and Contributors automatically have edit/build rights to the dataset, which bypasses RLS filters when they consume reports inside the workspace. Changing the affected users from Member to Viewer removes those elevated permissions, so the EastRegion role is applied and they see only data for the East territory. Disabling Build permission, republishing with bi-directional filtering, or publishing through an app will not override the fact that the Member role bypasses RLS within a workspace.
Ask Bash
Bash is our AI bot, trained to help you pass your exam. AI Generated Content may display inaccurate information, always double-check anything important.
What is Row-Level Security (RLS) in Power BI?
Open an interactive chat with Bash
Why does the Member role bypass RLS in Power BI workspaces?
Open an interactive chat with Bash
How does the Viewer role enforce RLS in Power BI?
Open an interactive chat with Bash
Microsoft Power BI Data Analyst
Manage and secure Power BI
Your Score:
Report Issue
Bash, the Crucial Exams Chat Bot
AI Bot
Loading...
Loading...
Loading...
Pass with Confidence.
IT & Cybersecurity Package
You have hit the limits of our free tier, become a Premium Member today for unlimited access.
Military, Healthcare worker, Gov. employee or Teacher? See if you qualify for a Community Discount.
Monthly
$19.99
$19.99/mo
Billed monthly, Cancel any time.
3 Month Pass
$44.99
$14.99/mo
One time purchase of $44.99, Does not auto-renew.
MOST POPULAR
Annual Pass
$119.99
$9.99/mo
One time purchase of $119.99, Does not auto-renew.
BEST DEAL
Lifetime Pass
$189.99
One time purchase, Good for life.
What You Get
All IT & Cybersecurity Package plans include the following perks and exams .