Forum Discussion

Khristian's avatar
Khristian
Icon for Resolver I rankResolver 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....

patrickoliver's avatar
patrickoliver
Icon for Advocate III rankAdvocate III
9 years ago

We're having a similar issue. We have RLS set up as a role against one of our tables but, because Analyze to Excel exposes the whole data model behind the report to the user, they can see other data if they choose to exclude the table that has the RLS on it from their PowerPivot reporting.