On premise data gateway, invalid username or password error for SSAS
I try to make a connection to my SSAS cube via Standard on-premise data gateway and I always get an invalid username or password error!
Here are the configuration that I did after reading troubleshooting doc:
The gateway service run with my windows account, this acccount is administrator on the server.
My UPN and windows account are set correctly in our organization AD. TGGAU is set correctly for our domain.
The command "whoami /upn" return the good email adress used to connect to PowerBI service.
The SSAS server belong to the organization domain.
All the other connection type like Sql server, Excel file are working properly.
We use Sql Server 2019 Enterprise version.
When I try to run a report (with SSAS as datasource correctly configured) in Power BI service, I see the trace on SSAS (profiler) and I see that the NTDomainName and NTUserName are passed correctly to SSAS, but an invalid username or password message is generated.
In SSAS, my account is a server administrator and I add the account as full control role for the SSAS database.
We use a specific port to access the SSAS server, not the default one.
In SSMS, when I try to connect to SSAS with the Additionnal Connection Parameters : EffectiveUserNamefirstname.lastname@example.org, I am not able to connect, it generate the same error as I have with the gateway.
What am i missing? It's been quite a while that I am trying to figure out what I do not do correctly.
Yes I did. I verified every aspect included in this article, listen to both video.
I also change the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.configfile
to set the ADUserNameLookupProperty and the ADUserNameReplacementProperty with my email-UPN has describe in the document without any success. The only thing I did not do is to set a value for the ADServerPath. Since the AD name resolution is running, I do not think it has any effect with my problem.