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

[mana_d]

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

User Table: This Table contain user and their email id

User

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

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

Fact Sales

data_M

Can someone please help to implement DRLS in this scenario?

Many Thanks

[Anonymous]

@mana_d,

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

[mana_d]

Hi @Anonymous

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