Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Arez2017
Helper I
Helper I

SSAS - Connection String using Alias server

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,

1 REPLY 1
v-qiuyu-msft
Community Support
Community Support

Hi @Arez2017,

 

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

 

Best Regards,
Qiuyun Yu 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.