Error: the on-premises data gateway's service account failed to impersonate the user

[liudmila]

Hi, I've got the ussue "the on-premises data gateway's service account failed to impersonate the user" when try to add a new data source.

Gateway service account is domain user, Data Source Type is Analysis Services. 

What can  be the reason?  Found many people with the same issue but cannot find a right solution.

Thank you.

[Anonymous · Accepted solution]

Hi  @liudmila ,

You can try the following:

1. This could also be a domain issue with the username. When you use the Analysis Services data source, the email address used to log in to Power BI will be passed to Analysis Services through the gateway as a valid user.

So the email address must match a defined user principal name (UPN) within the local Active Directory domain.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas

2. You need to add your user account to the server role in your SSMS Analysis Server --> properties> security, and then restart the gateway to refresh the data set.

https://docs.microsoft.com/en-us/analysis-services/instances/grant-server-admin-rights-to-an-analysi...

3. Update the gateway to the latest version

https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-update

This is the related document, you can view this content:

https://stackoverflow.com/questions/57750333/error-when-trying-to-configure-power-bi-data-gatwewy

https://community.powerbi.com/t5/Issues/on-premises-data-gateway-s-service-account-failed-to-imperso...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Sania-F]

I was using windows authentication method and was getting error. Just had to add domain name  domainname\username and the connevction got created.