Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MarceloPereira
Frequent Visitor

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/en-us/analysis-services/tutorial-tabular-1200/supplemental-lesson-impleme..., but the role does not work.

 

I created a little model to test, like this:

Model.PNG

 

after that, I created the role and add my 3 members:

Role.PNG

 

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

result.PNG

 

I tried chande the relationship between the tables in the tabular model, but didn't work.

Anybody can help me, please?

 

regards,

 

Marcelo.

Marcelo.

1 ACCEPTED SOLUTION
d_gosbell
Super User
Super User


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

View solution in original post

4 REPLIES 4
Salvador
Responsive Resident
Responsive Resident

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.

Hi @Salvador...

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

But now it works very well.

best regards. 

d_gosbell
Super User
Super User


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

Hi @d_gosbell ... 

Thank you so much for you help.

I really forgot that I was taular model admin. I created others users to test and the role worked very well!

best regards.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors