SSAS - Connection String using Alias server

Arez2017 — Tue, 30 Jan 2018 09:30:17 GMT

Hello Community,

I have created an alias for a server on which I have installed PowerBI Report Server ans SQL Server Analysis Services.

The connection string is now like this :

Data Source=serverName : portNumber;Initial Catalog=xxxxxx_SSAS;Cube="xxxxxxxModel"

So, it should be now :

Data Source=aliasServer : portNumber;Initial Catalog=xxxxxx_SSAS;Cube="xxxxxxxModel"

However, I am getting error that it is not possible to connect to the server. Is it supported to connect to Analysis Services via alias server in PowerBI?

Many thanks,

Re: SSAS - Connection String using Alias server

v-qiuyu-msft — Fri, 02 Feb 2018 01:34:09 GMT

Hi Arez2017,

Please check if you can connect to the SSAS in SSMS via alias server firstly.

Best Regards,
Qiuyun Yu

topic Re: SSAS - Connection String using Alias server in Report Server

SSAS - Connection String using Alias server

Re: SSAS - Connection String using Alias server