You published a semantic model to the Power BI service that contains two pre-defined row-level security (RLS) roles named EuropeSales and AmericaSales. The Europe regional director asks that all members of the Azure AD security group named "EU Sales Reps" automatically receive data filtered by the EuropeSales role without needing to republish the model each time the team changes. What should you do?
Add the "EU Sales Reps" group to the Members role of the workspace that contains the dataset.
Edit the EuropeSales role in Power BI Desktop, enter the object ID of the "EU Sales Reps" group as a DAX filter, and republish the semantic model.
Create a row-level security assignment for the "EU Sales Reps" group in Azure Active Directory; the assignment will be applied automatically in Power BI.
Open the dataset's Security settings in the Power BI service and add the "EU Sales Reps" Azure AD group to the EuropeSales role.
Row-level security role membership is administered in the Power BI service, not in Power BI Desktop. In the dataset's Security page you can add individual accounts or Azure AD groups to a role. Adding the security group "EU Sales Reps" to the EuropeSales role means every current or future member of that group is evaluated under the role when they query the model. Workspace roles, sharing a report, or making changes in Azure AD do not, by themselves, connect the group to the RLS role, so those actions would not apply the correct filter.
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
How do you add Azure AD groups to an RLS role in Power BI service?
Open an interactive chat with Bash
Why can't workspace roles replace RLS role assignments for filtering data?
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 .