Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ()
User Table: This Table contain user and their email id
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.
Fact_Sales Table: This contain sales data at location (City) level.
Can someone please help to implement DRLS in this scenario?
Many Thanks
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |