cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
minh23tran Regular Visitor
Regular Visitor

Adding members or groups to Row Level Security

Hi,

I was following this tutorial https://youtu.be/qrlq9sZyjug?t=289 and I can't follow it any longer because RLS has been moved to Desktop.

 

The steps to add a person was to click on dataset's elipse, add email addresses or groups. But since RLS has been moved to Power BI Desktop, how would you do that? 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team sirui_sun
Power BI Team

Re: Adding members or groups to Row Level Security

Hello! 

 

The steps for setting up RLS are:

 

  1. Define the roles in desktop
  2. Upload the PBIX file to the service
  3. In the service, clicks on the dataset's ellipses > Security
  4. Add users to the roles that you created in desktop

Take a look at the Row-Level Security documentation for more information: 

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

 

7 REPLIES 7
Power BI Team sirui_sun
Power BI Team

Re: Adding members or groups to Row Level Security

Hello! 

 

The steps for setting up RLS are:

 

  1. Define the roles in desktop
  2. Upload the PBIX file to the service
  3. In the service, clicks on the dataset's ellipses > Security
  4. Add users to the roles that you created in desktop

Take a look at the Row-Level Security documentation for more information: 

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/

 

DataDiva Regular Visitor
Regular Visitor

Re: Adding members or groups to Row Level Security

I'm sorry, I'm really confused and very stuck here! When I follow the directions given in the solution, I still get the same thing "RLS have moved to Power BI Desktop". I'm able to create roles and define them in Power BI Desktop, but there's no way I can see of adding members to those roles. I seem to be stuck in a loop, where Service is telling me to go to Desktop but the instructions say to add members in the service. Please help! 

ubiqtus Frequent Visitor
Frequent Visitor

Re: Adding members or groups to Row Level Security

This has been changed.  How do we accomplish this using Power BI Desktop?

 

Version: 2.49.4831.521 64-bit (August, 2017)

 

MB

DataDiva Regular Visitor
Regular Visitor

Re: Adding members or groups to Row Level Security

I finally figured it out. It requires both power BI desktop (where you go to "Manage Roles" and define the roles) and then the online service, where you add email addresses to the roles you defined in desktop. you have to go to "datasets" and then select the three dots and go to "security" and then you can see the roles you've defined in the desktop, and you can add emails. 

Chinoos Frequent Visitor
Frequent Visitor

Re: Adding members or groups to Row Level Security

Is there way to add 500 people in one go. Now I'm adding one-by-one, which is tedious job

omrdmr Regular Visitor
Regular Visitor

Re: Adding members or groups to Row Level Security

Hi @Chinoos,

 

I am also in a position to add nearly 600 users to a security role. Have you found a simple way for this?

 

Thanks

Highlighted
ekimrenrob Frequent Visitor
Frequent Visitor

Re: Adding members or groups to Row Level Security

Instead of a list of user names, create a list of user emails, separated by semi-colon. Paste those into the "people or groups" text box, click Add, then Save. Don't forget to save! (And I recommend testing this out with a couple emails before doing en masse).