I'm trying to schedule a refresh through service on SSAS.
I've set up the gateway and it reaches the SSAS instance without a problem.
However, I get this error when I try to refresh
My UPN is firstname.lastname@example.org and that's what says in the blurred line in the underlying error message
However the admin on the SSAS instance is 'MATRIX\neo'
I tried to Map the user names in the service so that 'email@example.com' becomes 'MATRIX\neo' but that doesn't work either.
The gateway is installed on a local server and 'firstname.lastname@example.org' is managing that gateway.
What am I doing wrong here ?
It seems this issue comes from the SSAS server. Please refer to xml-for-analysis-parser-the-domainuser-value-of-the-effectiveusername-xml-for-analysis?forum=sqlanal....
>>>Turns out that you need the SP Farm service account to be an admin on the SSAS server as well. That fixed the problem for us.