cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
LeonardoVega Frequent Visitor
Frequent Visitor

Problems whit SSAS live conection

Good Morning.
I have several problems with power bi desktop.
1.- I can't connect to a server using a vpn. The customer gave me a vpn to connect to your database. The problem is that I can't connect to the SQL Server Analysis Services database.
It says the server name is incorrect. The only way I can connect to SSAS is by using the runas command in cmd to run the program with the domain and the server administrator.

manchester runas.png

I need to find a way to connect to the VPN without the need to use cmd commands.

 

2.- Once connected to SSAS in live connection mode, I cannot customize the reports.

MANCHESTER ERRORES.png

I need create a measure and column in the report but most of the features of power bi are not enabled.
I have the need to specify roles in the roles manage to end users.
I need help solving these problems.

These two problems are from the same report.
Do you have any ideas?
Thank you so much.

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-sihou-msft
Moderator

Re: Problems whit SSAS live conection

@LeonardoVega

 

1. Since you need VPN to connect your database remotely, you have to the runas command to run Power BI Desktop. It's not supported to connect directly within Power BI Desktop.

 

2. When you open live connection to SSAS server, it's not supported to edit the source model. Currently, only Tabular model supports creating measures in Power BI Desktop. For multidimensional cubes, you can't create any measures or calculated columns.

 

Connect to SSAS Multidimensional Models in Power BI Desktop

Analysis Services Tabular data in Power BI Desktop

 

Regards,

 

 

2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: Problems whit SSAS live conection

@LeonardoVega

 

1. Since you need VPN to connect your database remotely, you have to the runas command to run Power BI Desktop. It's not supported to connect directly within Power BI Desktop.

 

2. When you open live connection to SSAS server, it's not supported to edit the source model. Currently, only Tabular model supports creating measures in Power BI Desktop. For multidimensional cubes, you can't create any measures or calculated columns.

 

Connect to SSAS Multidimensional Models in Power BI Desktop

Analysis Services Tabular data in Power BI Desktop

 

Regards,

 

 

LeonardoVega Frequent Visitor
Frequent Visitor

Re: Problems whit SSAS live conection