Forum Discussion
Row level security in Power BI
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
To define security roles, follow these steps. Import data into your Power BI Desktop report, or configure a DirectQuery connection. Note You can't define roles within Power BI Desktop for Analysis Services live connections. You need to do that within the Analysis Services model. From the Modeling tab, select Manage Roles. Select Manage Roles From the Manage roles window, select Create. Select Create Under Roles, provide a name for the role. Under Tables, select the table to which you want to apply a DAX rule. In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.
Admin