Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

RLS - How to Create Groups

Hello,

I am trying to implement RLS in Power BI.

On the Desktop, I have created Roles and Assigned Rules to them.

In the Service, I can add users one by one.  But I need to add hundreds of users via a group.  

 

Can anyone please provide step by step instructions on how to create groups of users that I can enter so I don't have to enter users individually?

 

pkbidani_0-1642439807453.png

Many Thanks!!

 

Pavan

 

1 ACCEPTED SOLUTION
v-yetao1-msft
Community Support
Community Support

Hi @Anonymous 

You can create a group in Microsoft 365 admin center with global admin or user admin . Then you can add user in the group you created before .

Microsoft's official documentation details how to create groups and how to add users to groups, you can refer to it .

https://docs.microsoft.com/en-us/microsoft-365/admin/create-groups/create-groups?view=o365-worldwide

Ailsamsft_0-1642652179773.png

Then you can search and add the group in RLS .

Ailsamsft_1-1642652179775.png

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yetao1-msft
Community Support
Community Support

Hi @Anonymous 

You can create a group in Microsoft 365 admin center with global admin or user admin . Then you can add user in the group you created before .

Microsoft's official documentation details how to create groups and how to add users to groups, you can refer to it .

https://docs.microsoft.com/en-us/microsoft-365/admin/create-groups/create-groups?view=o365-worldwide

Ailsamsft_0-1642652179773.png

Then you can search and add the group in RLS .

Ailsamsft_1-1642652179775.png

Best Regard

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi Collin,

Many Thanks!  I do like Guy In A Cube videos.

I this video, it shows how to use the Groups he alread created.

I am looking for step by step guidance on how to create the groups.

Regards,

Pavan

Hi @Anonymous ,

 

This is laid out pretty well by @GilbertQ in the post below.  The answer to your specific question about exactly HOW to do it depends a bit on the group you pick.  For example, if you are using Security Group, that is created in ADD or O365.

Power BI – Which Groups can be used to set Permissions in Power BI - Reporting/Analytics Made easy with FourMoo and Power BI

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




collinq
Super User
Super User

Hi @Anonymous ,

 

This link should help show you want you are asking:

Can you use GROUPS with Power BI Row-Level Security (RLS)??? - Guy in a Cube

 




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors