Ssas and gateway not in domain

Marcox28 · ‎02-22-2022

Hi all

I have a problem when I publish reports in live query. i have two servers with no domain so all services are started with local accounts. i have problems when the service tries to impersonate the local user of the ssas server. does anyone know if it is possible? on the web I find only as a solution to join a domain but for me it is not possible.

GilbertQ · ‎02-22-2022

Hi @Marcox28

As far as I am aware what you could do is to change it from a Service account to use a local account.

Create a local user account on your server. Make sure that your local account has got the right permissions to be able to run SSAS (which as far as I am aware would be the same rights as local system which is very close to Admin rights)

Use this new local user account for your SSAS Service.

Restart the SSAS Service to make sure it works as expected.

Now use this same local user account in the Power BI Gateway and see if that works?

Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Power BI Blog