Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I've been trying to use CustomData to provide the logged-in user's e-mail ID so that I could filter cube data based on that CustomData value.
The problem is that if I use CustomData then the EffectiveUsername is the OLAP Administrator (which is what is configured in the gateway's cube data source). This completely bypasses any cube security.
If, however, I use EffectiveUsername instead of CustomData, I only see the email in Profiler logs but what I see in the USERNAME field is DOMAIN\USER not the e-mail of the user accessing the cube?
Does anyone know of a way to access the logged in user's e-mail from the cube or is there any way the SSAS cube can be accessed without using an administrator account for the data source credentials?
Thanks in advance.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.