Forum Discussion

medonication's avatar
medonication
Helper I
4 years ago
Solved

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!

  • Anonymous's avatar
    Anonymous
    4 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

  • Anonymous's avatar
    Anonymous
    Not 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