Forum Discussion
Row Level Security Multidimentional Access
Hello Everybody,
I want to talk with you about the best way to built a security concept based on mutiple dimensions.
e. g. we have a list of users which should only see data based on their country/region, their product line and their vehicle line.
If we define a user to see for example only EU as a region and light vehicle as a vehicle line but a * in the product (Mean he can see all the product in EU only for Light Vehicles)
I used a code to do that but it looks too overwhelming and hard to update.
I believe there is a better and performanter way to handle my problem.
Thank you for your ideas!
- Anonymous4 years ago
Hi medonication,
Perhaps you can create a mapping table of username and corresponding region, then link this to the country/region table based on the country/region field.
After these steps, you can use the username to lookup the country/region and extract this to apply 'RLS filter' on the country/region table to filter records.Solved: RLS with UserName() - Microsoft Power BI Community
Regards,
Xiaoxin Sheng
1 Reply
- AnonymousNot applicable
Hi medonication,
Perhaps you can create a mapping table of username and corresponding region, then link this to the country/region table based on the country/region field.
After these steps, you can use the username to lookup the country/region and extract this to apply 'RLS filter' on the country/region table to filter records.Solved: RLS with UserName() - Microsoft Power BI Community
Regards,
Xiaoxin Sheng