Forum Discussion

Khristian's avatar
Khristian
Resolver I
10 years ago
Solved

RLS Analyze in Excel

Hi everyone!   Into the PBI documentation, the RLS rules applied into powerbi desktop should run in Analyze in Excel too, but it does not....   Any one of you have the same problem?  
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    10 years ago

    Hi nbailey,

     

    We can define the roles in Power BI desktop, but after publishing to the service, we need also add members under this role to take effect for this user. We can also use Test as role to check results. I would suggest you to take a look at this article: Row-level security (RLS) with Power BI (Preview).

     

    Best Regards,
    Qiuyun Yu

  • Khristian's avatar
    Khristian
    6 years ago

    i did this.

     

     

    Well, i faced the samething... now it works....

     

    well, i create my model into powerbidesktop feed it from sql data base....

     

    Then a RLS is created and tested into the powerbi desktop too..

     

    If it work....

     

    A Group is created into powerbi service

     

    the model is published into a GROUP ,  this group is set "Member can only view powerbi content"

     

    You be sure the user´s you add into that group has a powerpro profile

     

    So try into powerbi publisher for excel, and works....

nbailey's avatar
nbailey
Advocate I
10 years ago

Thank you for the clarification (when RLS was managed in PowerBI.com previously - before it was brought into be managed in Desktop, it was possible to put myself in different roles to test visuals, so this is different behavior now).  So the only place we now have the ability to "test" roles is in the PowerBI Desktop, which means we don't have the ability to test any content created on PowerBI.com.  This will make it more difficult to troubleshoot end user issues (or validated security) on PowerBI.com content.

v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi nbailey,

 

We can define the roles in Power BI desktop, but after publishing to the service, we need also add members under this role to take effect for this user. We can also use Test as role to check results. I would suggest you to take a look at this article: Row-level security (RLS) with Power BI (Preview).

 

Best Regards,
Qiuyun Yu