Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

Row level Security not working right now?

Hi, could anyone confirm that the RLS is not working at the moment? the RLS setting I set up worked before. But today not working. If I do a test data as role, it works - which means my DAX and othe...
Need Help
GuyInACube's avatar
GuyInACube
Administrator
10 years ago

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/

jickes's avatar
jickes
Helper I
10 years ago

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?

  • GuyInACube's avatar
    GuyInACube
    Administrator
    10 years ago

    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.

     

     

  • HBMIRA's avatar
    HBMIRA
    Frequent Visitor
    10 years ago

    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.

     

     

  • jickes's avatar
    jickes
    Helper I
    10 years ago

    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. 

  • jickes's avatar
    jickes
    Helper I
    10 years ago

    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.