cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

Cannot connect with SSAS in Gateway

Hi

 

I've been tying to create a gateway to connect to a cube from SSAS but I cant, this is the problemSSAS SISPRO.png

Im 100% rigth about the connections credentials. Im doing this becuause I cant connect from Desktop, so I readed that It is neccesary to create a Gateway... but... I cant... 

 

PD: From Excel I CAN connect to that SSAS server.  

4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Cannot connect with SSAS in Gateway

@AlejandroPCar,

What version of SSAS do you use? Are you able to connect to SSAS server from SQL Server Management Studio(SSMS) in the machine that installing gateway with same connection strings?

Besides, do SSAS server and gateway locate in same domain?

Regards,
Lydia

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

Re: Cannot connect with SSAS in Gateway

@v-yuezhe-msft,

Hi, Im very new using SSAS so... hahahaha I dont understand much that you are asking, but I cant connect from SQL Management Studio, this is the result: SSAS SISPRO2.png

 Hope this can help us to understand what is happening

 

thanks for your response

Moderator v-yuezhe-msft
Moderator

Re: Cannot connect with SSAS in Gateway

@AlejandroPCar,

This is a SSAS connection issue. It seems that you use unsupported authentication method to connect to SSAS, see https://social.technet.microsoft.com/wiki/contents/articles/15274.using-claims-authentication-across....

In your scenario, please use Windows authentication to connect to SSAS database.

Regards,
Lydia

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

Re: Cannot connect with SSAS in Gateway

After a lot of searching, the SSAS server's creator said me that there is no way to connect trough Power BI, so... 

 

Well, thanks a lot for your help anyway @v-yuezhe-msft