PBI Gateway > SSAS: "The Following system error occurred: The user name or password is incorrect. "

[Riktastic]

Hi PBI community,

I'm in a struggle with getting the PBI Gateway to source data from a SSAS Tabular instance to a PBI Service report.

The situation:

- SSAS, the gateway and the connection are using the same service user (DOMAIN\svc_PowerBiGatewayUs). All three are working just fine. SSAS starts and works fine after changing the service in "Services". The gateway also runs fine and is able to return data from a SQL Server-database.

- The service user is just a normal Active Directory user which resides in the same domain as all the other users,
- The same service user can open a SQL Server-database on the same system,

- The user mapping seems correct. UPN (Riktastic@domain.com) are mapped to Win2000-domain logins. (DOMAIN\Riktastic),

What I think is remarkeable: The "SQL Server Profiler" returns only 1 error, in which it reports that the username/password of the service user is incorrect:

Error The following system error occurred: The user name or password is incorrect. 12 svc_PowerBiGatewayUs 2023-11-01 11:59:53.000 2023-11-01 11:59:53.000 0 103 DOMAIN

I have installed many gateway before, but have never encountered this exact situation. Whenever I received the  "The Following system error occurred: The user name or password is incorrect. "-error it was because the Gateway was being executed as a local user, which was unable to impersonate a domain user.

Is there someone who has been in the same situation a I have? 

Kind regards,

Riktastic

[Riktastic · Accepted solution]

I've solved this issue by adding the service user to the "Builtin\Windows Authorization Access Group". 

To sum everything up:

- I had to run SSAS as the service user,
- I had to run the On-premise gateway as the service user,

- Make the service user a SSAS server administrator,

- Add the service user to the "Builtin\Windows Authorization Access Group",

- Fill in the correct user mapping while configuring the Power BI Service connection,

- Make sure the TGGAU-property was set properly: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot#error-we-encou... 

[lbendlin]

Just to clarify - your SSAS Tabular instance is on-premise?  Does the gateway connection user have Discover permissions on the cube?

[Riktastic]

Hi @lbendlin , I have given the user server administrator rights. I think that these rights also assign the Discover permission.
https://learn.microsoft.com/en-us/analysis-services/instances/grant-server-admin-rights-to-an-analys...

PS: It is a On-premise installation.

[lbendlin]

sounds about right (although I don't know if there is a difference between server admin and cube admin).

If you have a Pro license you can open a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi - otherwise you can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues .

[Riktastic]

Hi @lbendlin thanks for helping me. This issue is quite complex. It migth be a Active Directory policy or a bug in the Gateway software that is bothering me.

P.S.: cube admin is for a SSAS cube, server admin is for a tabularmodel

[lbendlin]

The ticket is the quickest way to get answers.

[Riktastic]

Thanks for helping me!