cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper IV
Helper IV

Re: Row level Security not working right now?

@Eric_Zhang The warning shown is a known issue. You can only set up RLS on Power BI service at the dataset level. And the preview feature does not seem to be working.

Highlighted
New Member

Re: Row level Security not working right now?

I wonder whether the issue stems from a mismatch between the May version of PB Desktop & what I would expect will be released in the June update of the tool? An older (solved) thread on this same topic led me to this article, where it talks about RLS as a feature added to the desktop. May release of the software (as of this morning, still the only version in download), this feature is missing...

 

Hope I'm not being just a stupid user, can anyone confirm they are missing the desktop Preview option to "Enable cross-filtering in both directions for DirectQuery" and also the "Manage Roles" option under Modelling that are mentioned in the article?

 

powerbi-desktop-security.png

 

Highlighted
Helper IV
Helper IV

Re: Row level Security not working right now?

@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. 

Highlighted
Helper IV
Helper IV

Re: Row level Security not working right now?

@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.

View solution in original post

Highlighted
Microsoft
Microsoft

Re: Row level Security not working right now?

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/

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube
Highlighted
Helper I
Helper I

Re: Row level Security not working right now?

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?

Highlighted
Microsoft
Microsoft

Re: Row level Security not working right now?

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.

 

 

Adam W. Saxton | Microsoft Employee | Business Intelligence
@GuyInACube | youtube.com/guyinacube
Highlighted
Frequent Visitor

Re: Row level Security not working right now?

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.

 

 

Highlighted
Helper I
Helper I

Re: Row level Security not working right now?

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. 

Highlighted
Helper I
Helper I

Re: Row level Security not working right now?

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. 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors