RLS Security Issue in Service

[Razorbx13]

Hi all, hopefully you can help me with this issue.  Maybe I missed a step.  I have a simple table with a Security Key and a Username.  Username is email.  I setup a Role to this table and filter as Username = USERPRINCIPALNAME().  In the desktop I us "View as Role" and it works fine.  Filters for my email/username.  I publish to Service and associated my email in the security for the dataset and then Test the Role.  Works fine.  Exit and then go create a report on this dataset.  NO SECURITY APPLIED.  Should it not be working?  Did I miss a step?  This is about as simple as it gets, and is Step 1 in my security process.  Thanks in advance!

[GilbertQ · Accepted solution]

Hi @Razorbx13 

The reason you see all the data is because you created the dataset. And a creator of a dataset will ALWAYS see all the data (or is the administrator of the data)

Try and do this with a user who either has viewer role in the app workspace or share it via an App or report and it will apply the RLS.

[Razorbx13]

Gilbert, thanks this worked!  So for RLS to work, you cannot make the user have Member or Contributor access?  Has to be viewer access?  If so, I assume then Analyze in Excel is out of the question too?