Forum Discussion
Establishing Row Level Security on SSAS Model connecting via Custom Data (Service Account email)
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?
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.
3 Replies
- lbendlin
Super User
only if you get the passthrough to work.
Would you be elaborate around what pass-through feature did you refer here? I dont know what that means.
- lbendlin
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.
