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...
'@Haggagy Sleem, pleasure! I can confirm that this is still working and we are still using this approach successfully. The steps are accurate to me but perhaps I have not made them clear enough. some things to try: - Make sure your non-admin account is getting through to your RLS Roles when connecting locally - use Profiler to verify the connection string coming through to SSAS from the Gateway - make sure the Gateway is sending CustomData () in Power BI Gateway Admin - make sure the attribute on AD for Admin account is set and you have put that attribute correctly in the gateway config under ADUserNameReplacementProperty (i used "description"), - also remember that the gateway is finding the admin account in AD using the ADUserNameLookupProperty, I used "userPrincipalName"(email), however you may need to use SAMAccount if you entered the Admin credential in gateway datasource that way etc. When is works you will see in profiler connect with Admin Acc, Effective will be Non-Admin Acc, and then can use CustomData for your RLS rules.
