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

Khristian's avatar
Khristian
Resolver I
9 years ago

i´m pettry sure, RLS does not applied in powerpivot models, you most change the model into powerbi desktop

 

Regards

patrickoliver's avatar
patrickoliver
Advocate III
9 years ago

Our model is against an on premise SQL Server database. The problem is that whatever the data source is and however much of it is exposed in the Power BI report, you can get to all of the data that was in the Power BI Desktop model through the Analyze in Excel functionality.

  • Khristian's avatar
    Khristian
    Resolver I
    9 years ago

    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
      Advocate III
      9 years ago

      I tried publishing to a Group Workspace as you suggested (with the view only setting). The user (who has a trial Power Pro licence) could see all of the underlying data using "Analyze in Excel" as long as they avoided the table that has the RLS roles against it.

      • Khristian's avatar
        Khristian
        Resolver I
        9 years ago

        Well i guess you didn´t get the perfomance you wanted, so, the RLS should be tested....