Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
We tried to use the customdata radio button in the "Map User Name" section of the Power BI Gateway connection.
However, the properties passed to Analysis Services are the CustomData property containing the AzureAD UPN and the EffectiveUserName which contains the SSAS Administrator account that was used to establish the connection in the gateway. It is not possible to use a non-administrator account to establish the connection to the gateway. Because the EffectiveUserName contains the SSAS Administrator account, the security does not get applied because Analysis Services does not allow Row Level Security to be applied to SSAS Administrator.
It would seem that the correct thing to do would be to not pass the EffectiveUserName property or to allow us to change the EffectiveUserName that is sent for this purpose to be a non-admin account.
At this time, it seems that the feature does not work and there is no way to use it properly,
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.