cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mana_d Frequent Visitor
Frequent Visitor

How to apply Dynamic RLS in location hierarchy and user access, with many to many relationship

Hi All,

I am new to power BI DRLS, would like some help in below scenario.

Scenario: One user can have access to many locations and one location can be access by many user.

For example User A can access sales data for Edinburgh, Glasgow & Bristol and user B can access Glasgow, London & Bristol

Location table: This table has four level hierarchy MD > Country > Region > City, path column has been populated by  DAX PATH ()

Location.JPGLocation

User Table: This Table contain user and their email id

User.JPGUser

User_profile Table: This is bridge table and hold relationship between user and their location, with many to many relationship. One user can have access to many location and one location can be access by many users.

User_profile.JPGUser_Profile

Fact_Sales Table: This contain sales data at location (City) level.

Fact_Sales.JPGFact Sales

Data_model.JPGdata_M

 

Can someone please help to implement DRLS in this scenario?

 

Many Thanks

2 REPLIES 2
NickNg278 Senior Member
Senior Member

Re: How to apply Dynamic Row level security in organisation hierarchy with many to many relationship

@mana_d,

I never tried but you could take a look at this article to see if it helps

mana_d Frequent Visitor
Frequent Visitor

Re: How to apply Dynamic Row level security in organisation hierarchy with many to many relationship

Hi @NickNg278

 

Thanks for your reply, the article which you referred is different from my scenario. IT does not include hierarchy with M-2-M relationship.

 

Regards