Forum Discussion
Can't Get RLS to Work
- 10 years ago
With this latest release, it should work with Groups in Power BI. The catch is that the group has to be configured that members have read-only access. Then the role will be applied to the read-only members. If they are marked to have edit rights, the roles will not be applied.
Hi Adam,
I followed your useful post on RLS.
I still have an issue when I want to map Power BI (O365) groups row level security roles.
Indeed, I have created one Group on Power BI which name is powerbi_testrls which have read access only as mentioned.
I've created a rôle which name is User US which implement row level security.
When I click on my dataset > security, I see all my organisation emails but I don't see my Power BI Group.
Maxime Gouffé
If you publish your Power BI Desktop report to a workspace within the Power BI service, the roles will be applied to read-only members. You will need to indicate that members can only view Power BI content within the workspace settings.
Note: If you have configured the workspace so that members have edit permissions, the RLS roles will not be applied to them. Users will be able to see all of the data.
Read more at: Using RLS with workspaces in Power BI