Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Map User Name with Custom Data does not work - this is a bug

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

Status: Needs Info
Comments
v-haibl-msft
Employee

@sreinman

 

It seems that you have the same request as this idea. Could you please help confirm it?

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Needs Info
 
luisrh
Responsive Resident

It is the same.  but please fix this issue.. it is a very important workflow that is not currently working....

e2patrick
New Member

Same problem here. This seems to be a bad bug.