Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi
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 whatever@whatever.com 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 'whatever@whatever.com' becomes 'MATRIX\neo' but that doesn't work either.
The gateway is installed on a local server and 'whatever@whatever.com' is managing that gateway.
What am I doing wrong here ?
Hi @Yggdrasill,
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.
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.