Forum Discussion

MarceloPereira's avatar
MarceloPereira
Frequent Visitor
6 years ago
Solved

RLS using SSAS tabluar model doesn't work in PBIRS

Hi experts, I'm using the PBIRS to create any reports whare the source is a SSAS tabular model. I create all reports but now I nees apply the RLS. I used this tutorial: https://docs.microsoft.com/...
LiveConnection
RLS
  • d_gosbell's avatar
    d_gosbell
    6 years ago
    MarceloPereira wrote:

     

    When I run the report, we can see that each row appears 3 times, once for each member I include in my security table:

     

    So the fact that you created the role means you would be an admin on the server. Server level Admins do not get security roles applied to them, they can always see all the data. If you want to test a role in Power BI click on the modelling tab, then click on the "View As" option and choose the role you just created (or enter the login details of one of the role members who is not a server admin). 

     

    Note: this "View As" option only works for server admins, normal users cannot use this funtion.

Salvador's avatar
Salvador
Responsive Resident
6 years ago

Hello Marcelo,

 

You will have to add the user you are going to test in the role, then, from visual studio, go to extensions, model, Analyze in Excel, other windows user, and then, use the user you are going to test. That will open an excel with a pivot table, and you can check what that user can see.

 

Regards,

Salvador.

  • MarceloPereira's avatar
    MarceloPereira
    Frequent Visitor
    6 years ago

    Hi Salvador...

    It was a problem because I had no Office in the VM.

    But now it works very well.

    best regards.