Forum Discussion
RLS using SSAS tabluar model doesn't work in PBIRS
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.
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.