Row Level Security works on Desktop but not on Server Portal
HI, I have recently configured our on-prem report server, created some reports and TRIED applying RLS on the same reports unsuccessfully. RLS does work when I try VIEW AS on the desktop app but when I deploy it on the portal and run the report, the values are just blank. Here is the premise: I have the following table to control access to certain data called, ACCESS CONTROL. User | Company | Store DOMAIN\user.name | MyCompany 1 | MyStore 1 DOMAIN\user.name2 | MyCompany 1 | MyStore 2 I have also setup a measure to check for the current user, User2 = USERNAME() And then I created Role on the desktop app called, PERMISSIONS. That is filtering on the ACCESS CONTROL table using the following [User] = [User2] Finally, I added two slicers, one to show Company and the other to show Store. If I try this setup on the desktop app using VIEW AS, i get my SLICERS filtered correctly. I uploaded the report on the portal and ran it only to be greeted with access errors on all visuals. I, then, added the user on the report with the same role as PERMISSIONS and when I ran the report again I can see all reports but the SLICERS are blank. So, in the end did I miss something which is why me slicer is not showing correctly. I would appreciate all input regarding this matter.
I need to add 800 User in Row-Level-Security
Currently I have more than 800 user to add in a row-level-security. Which I know how to do it one by one on this page. However is there any faster way to do it. For instance can I upload excel file with user name and automatically add the row? Please can anyone advise. Thank in advance.
