Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row level security in Power BI

Hi All,   I am trying to implement Dynamic RLS in my organization . I was able to implement all the steps to setup DRLS in PBI Desktop and published to premium workspace. I have added a user group...
  • Anonymous's avatar
    Anonymous
    6 years ago

    HI Anonymous,

    You can try to migrate current group users to a security group. (use PowerShell scripts to batch operation automatically)

    Copy group members to another group 

    After these, you only need to assign the role to a new security group to enable the RLS effect instead duplicate this operation on each user.

    Row-level security (RLS) with Power BI 
    Notice: current RLS only works for read permission users, please not share edit permission or it will ignore RLS filter effect.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

You can try to migrate current group users to a security group. (use PowerShell scripts to batch operation automatically)

Copy group members to another group 

After these, you only need to assign the role to a new security group to enable the RLS effect instead duplicate this operation on each user.

Row-level security (RLS) with Power BI 
Notice: current RLS only works for read permission users, please not share edit permission or it will ignore RLS filter effect.

Regards,

Xiaoxin Sheng