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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

RLS in power bi service

I have implemented Row-Level Security (RLS) in the Power BI Desktop for an organizational hierarchy dashboard covering the entire organization, comprising 720 members. The RLS is based on a dynamic formula using the email = user principal name. After publishing the dashboard to Power BI Service, I now face the challenge of adding the email IDs of these 720 members. These members are clients of the company. How can I accomplish this task within the Power BI Service interface? and what is the best way to add these 720 members to make RLS work?

NOTE THAT 720 MEMBERS ARE FROM THE OTHER COMPANY [client] 

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

Its best to get a Distribution Group created and then add that DG in seurity option of Power BI
You can get thet DL created with help of your IT team, can also follow
https://answers.microsoft.com/en-us/msoffice/forum/all/add-bulk-users-in-distribution-group/795cc489... if you have enough previlegde.


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

1 REPLY 1
arvindsingh802
Super User
Super User

Its best to get a Distribution Group created and then add that DG in seurity option of Power BI
You can get thet DL created with help of your IT team, can also follow
https://answers.microsoft.com/en-us/msoffice/forum/all/add-bulk-users-in-distribution-group/795cc489... if you have enough previlegde.


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.