Establishing Row Level Security on SSAS Model connecting via Custom Data (Service Account email)

[jinsigeorge]

I am trying to establish a row level security for few users on an SSAS model that is connecting via OnPrem gateway. I am using Power BI Service which connecting to the SSAS model via a Service account credential. The Service account is set up with a Custom data user name set up. Using the effective user name set up returns a data source error and hence we have to pass the service account email as custom data to successfully extract the data from SSAS.

Can a RLS be established using the custom data set up?

[jinsigeorge]

Would you be elaborate around what pass-through feature did you refer here? I dont know what that means. 

[lbendlin · Accepted solution]

the Effective Identity passthrough.  RLS can only work if the data source can uniquely identify the requesting user. It would be pointless to do this via the Service account.

[lbendlin]

only if you get the passthrough to work.