If you have an SSAS cube and you setup a gateway data source then go to User Mapping and switch the radio button to CustomData, the connection string used is now: [email protected];C...
'Hi All, I have managed to work around this issue. One can actually switch out the required Admin user from EffectiveUserName in the connection string... Once you are using CustomData in "Map User Name" and have your SSAS Admin Domain account set for the Gateway Datasource, do this: 1) Find another non-Admin domain account. 2) Make it a member of your RLS Role in SSAS. 3) Update a miscellaneous/unused AD property of the Admin Domain account (e.g. "description), set this property to the UPN of the non-admin RLS account. 4) Update your Gateway config to do a manual lookup, i.e. description userPrincipalName 5) Restart yoiur Gateway service. This will force the Gateway to intercept the EffectiveUserName! i.e. you will connect with Admin, Impersonate Non-Admin RLS, and then can use CustomData for your RLS rules. @PowerBI, I think this needs to be documented and shared because I searched for days and eventually managed to figure this out myself.
