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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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