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
Ullas_M
Regular Visitor

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors