Please help to check the issues that occur when Power Shell processes SSAS models for SQL Server.

Question

I have installed two instances of SQL Server, one is the multidimensional model (default) instance: DEFILT, and the other is the table model instance: MS1SERVER 2.

Now I need to use the 'Invoke ProcessTable' command in Power Shell to refresh the table of a certain table model in my MS1SERVER 2 instance,

But I am unable to enter under MS1SERVER 2 in the Power Shell, but can enter under the default instance DEFILT.

:

Answer 1

Hi @长成 罗,

Have you installed SSAS service for MS1SERVER 2?