Forum Discussion
Helper IRow level security with multiple roles & regions
Hi Friends,
It would be great help on solving below my query. Taking few days to crack. But still not
can we implement dynamic RLS with multiple role and multiple region assignment along with organisational hirarchy ( Using path i acheieved) ? On this hierarchy need to map role and region.
I try to use following model. But not working. PBIX file is in the below google link
https://drive.google.com/file/d/1zEKedFdEU0T7iq7S_jltEp-M50d1cHiL/view?usp=sharing
2 Replies
- lbendlin
Super User
Your roles don't seem to include the geo hierarchy?
Here's how I would structure the data model
You may also want to check this article
Managing hierarchical organizations in Power BI security roles - SQLBI
Krish_nidarHi lbendlin,
Thank you for your effort to provide solution.
Could you pls explain below query ?
In your model, dim_user table is having multiple user values,i guess ,But user should be unique. User-role table can be multiple users as multiple roles can be assigned to the same user.
I already achieved hirarchical RLS as eplained as per your link -Managing hierarchical organizations in Power BI security roles - SQLBI
