Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Weird gateway behaviour - SSAS MD

Hi all,   We have a solution that uses SSAS Multi Dimensional Cubes with Power BI service. It works for many of our customers, but with this recent customer, I cannot get it running.   I configur...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    After many more hours of investigation, we finally found a working solution.

     

    The service "SQL Server Analysis Services (MSSQLSERVER)" was running under the default user "NT Service\MSSQLServerOLAPService". Changing the service user to a domain service user (e.g. domain\svssas) made all issues go away. I still don't fully understand why, but we are just glad it works.

     

    Thank you GilbertQ for your support.

     

    Best,

    Marco

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi GilbertQ 

Thank you for your response. The SSAS Version is 2019 (15.0.32.55).

I also noticed that the "Change User" function in management studio does not work. It states that the username or the password is wrong:

Since the gateway is doing something similar like "change user" (I suppose), could this have something to do with it? And if so, how do I fix it?

GilbertQ's avatar
GilbertQ
Super User
4 years ago

Hi Anonymous 

 

Yeah that does seem to be an issue and to fix it I would search for now to get EffectiveUsername on SSAS MD?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi GilbertQ 

    Sorry, but I guess I need some more help. How do i get EffectiveUserName on SSAS MD?