Forum Discussion
Weird gateway behaviour - SSAS MD
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
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
Hi Anonymous
The reason it works is because when the service is running under a local system account such as "NT Service\MSSQLServerOLAPService" it cannot query Active Directory.
When you change it it to use a domain account, as you did above it allows it to then query Active Directory and lookup the users!Our power bi gateway is setup and declared SQL Analysis Service as data source with administrator on Gateway as well Service Account is set as administrator of SQL Analysis Service.
I am trying to created Data Flow with SSAS as data soure using Query generated from Power BI Desktop which is not working and presented with below error .
SSAS cube works absolutely fine with Power BI Desktop.
