Row Level Security Multidimentional Access

[medonication]

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!

[Anonymous · Accepted solution]

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