Forum Discussion
Row level Security not working right now?
- Anonymous10 years ago
tdimbladThe RLS is currently working with the June 2016 power bi update. You can now set up the role and rule in Power BI desktop. And it would not overwrite the role members in Power BI service, which is what is supposed to be. But on the power BI service, it still says it is a preview feature - so I guess we still can not use it for production.
tdimblad I can confirm that it is missing. I assume it will be in the June update as you can see the article was published 2-3 days ago. Apparently Power BI team has been working on this.
tdimbladThe RLS is currently working with the June 2016 power bi update. You can now set up the role and rule in Power BI desktop. And it would not overwrite the role members in Power BI service, which is what is supposed to be. But on the power BI service, it still says it is a preview feature - so I guess we still can not use it for production.
- GuyInACube10 years agoAdministrator
Yes it is still a preview feature. With the June 2016 release of Power BI Desktop the role creation was moved from the Power BI service to Power BI Desktop. Existing roles that were configured in the service will not work, and the roles need to be setup within Power BI Desktop and then published to the service.
The nice thing with that is republishing will not cause the roles to get blown away now. As they are part of the Power BI Desktop file.
Youl will still need to add members to the role within the Power BI service.
For more information about RLS, and a list of known limitations, you can check out the official doc.
https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/
- jickes10 years agoHelper I
I setup RLS in desktop, published it to the service and the RLS works in 'Test as Role' mode, but doesn't work when I push out the reports/dataset as a content pack to users. Are content packs not supported?
- GuyInACube10 years agoAdministrator
It is supported. I just tested on my end and it worked with a content pack to both my personal workspace as well as a group.
- HBMIRA10 years agoFrequent Visitor
Hello,
I am having difficulty updating my current dataset to work with the new RLS.
I've republished my dataset from the desktop client after creating and testing roles. When I click the 3 ellipses in Power Bi Service I am greeted with the dialog that RLS has been updated. Overwriting my current dataset is not refreshing or adding roles.
I published the same dataset with a different name and that one works with RLS in service but all our reports are tied to the dataset where RLS is not working.
- jickes10 years agoHelper I
I'm unable to get it to work. I'm publishing the dataset with RLS to a workgroup, adding my email to the role, then publishing the content pack to users and my personal workspace. The RLS does not have any affect except in "Test as Role" view.
- jickes10 years agoHelper I
Ok I figured my issue out, I guess I wasn't thinking that my email is an admin in the workgroup.
I published to a workgroup, added my email to the RLS role and published content pack to my personal workspace. The RLS doesn't work on it in my personal workspace because I'm an admin in originiating workgroup I guess? The RLS does work for users that are not admins in the originating workgroup.
- smolina7410 years agoFrequent Visitor
I'm using dynamic security (username()), so I shouldn't have to add any member to the role. I tried the role in power bi service and everything works (in test mode), but then when I try just the report in production, it doesn't. Any idea of what is happening?