Connecting to SSAS for a non domain user

[mohsenask]

Hi

Im new to PowerBI. We have the following arrangements;

We have SSAS cube setup on a remote server. Im trying to access the cube from PowerBI Desktop from a Windows 7 machine over the internet. Im not part of any domain and am trying to access the SQL server on the IP. Unable to connect to the SQL Server or the SSAS

Please advise on how this can be done.

Thanks

[Anonymous · Accepted solution]

Hi @mohsenask,

>>Unable to connect to the SQL Server or the SSAS

Based on document, the effective user name in connection string is "domain\user" format, you have to provide a domain to correctly convert the connection string.

Use when an end user identity must be impersonated on the server. Specify the account in a domain\user format. To use this property, the caller must have administrative permissions in Analysis Services. For more information about using this property in an Excel workbook from SharePoint, see Use Analysis Services EffectiveUserName in SharePoint Server 2013. For an illustration of how this property is used with Reporting Services, see Using EffectiveUserName To Impersonate in SSAS.

 EffectiveUserName is used in a Power Pivot for SharePoint installation to capture usage information. The user identity is provided to the server so that events or errors that include user identity can be recorded in the log files. In the case of Power Pivot, it is not used for authorization purposes.

For detail information, you can take a look at below articles:

Connection String Properties (Analysis Services)

Connect to SSAS Multidimensional Models in Power BI Desktop

Regards,

Xiaoxin Sheng