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 count...
Need Help
Tips and Tricks
  • 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

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