RLS on Azure Analysis service

Question

I have a fact table and 3 dim table partner ,region and user and my user table contains the usernames and there respective access i:e user1 amazon and America , user2 flipkar and canada , so when ever user 1 logs in he should only see amazon and America data.

Answer 1

Create a new role "UserSecurity". Then in the "Row Filters" tab for your role, add filters for each table.

Partner dimension :

Partner[PartnerName] = LOOKUPVALUE(User[PartnerAccess], User[Username], USERNAME())

Region dimension :

Region[RegionName] = LOOKUPVALUE(User[RegionAccess], User[Username], USERNAME())

The fact table :

CALCULATE(
    TRUE,
    FILTER(
        ALL(Partner),
        Partner[PartnerName] = LOOKUPVALUE(User[PartnerAccess], User[Username], USERNAME())
    ),
    FILTER(
        ALL(Region),
        Region[RegionName] = LOOKUPVALUE(User[RegionAccess], User[Username], USERNAME())
    )
)