Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.