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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
scoder
Frequent Visitor

RLSs security implement to different level of access restriction

I have a few dashboards built to show sales, revenue, expenses, usage etc , I need to build an access control for these dashboards 

High-level requirement access is

  1. There is a global head for each product, they should be able to access details across all regions and locations for the product they are head of. For example, the Global head for TV, can access TV sales across all regions and locations  
  2. Similarly, there will be a region head for each product, they should be able to access details across all locations in that region.  
  3. There will be a location co-head for each product, they can access details of that particular location for the product he/she is head of. 

And below is the sample table of product, region and location. 

ProductRegionLocation
TVAmericaTexas
TVAmericaNew York
TVEuropeGermany
TVEuropeItaly
TVGreater ChinaShandong
TVGreater ChinaZhejiang
TVJapanTokoyo
TVJapanKyoto
TVRest of AsiaIndia
TVRest of AsiaSingapore
MobileAmericaTexas
MobileAmericaNew York
MobileEuropeGermany
MobileEuropeItaly
MobileGreater ChinaShandong
MobileGreater ChinaZhejiang
MobileJapanTokoyo
MobileJapanKyoto
MobileRest of AsiaIndia
MobileRest of AsiaSingapore

 

So I am planning to design the roles as below 

  •   Roles for each product to be assigned to Global product heads 
  •   Roles for each product and region combination, are to be assigned to region heads 
  •   Roles for each product and location combination, to assign to location co-head 

But these would end up creating too many roles and also will have operation maintenance issues when a new product is added. 

 

is there a simple way in power-bi space to build ACL for these kinds of requirements? 

 

 

 

 

 

 

1 REPLY 1
Anonymous
Not applicable

You should be able to achieve this using PATH and USERPRINCIPALNAME functions. See RADACAD article here for more details Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

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.