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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors