cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AlejandroPCar
Helper IV
Helper IV

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
v-yuezhe-msft
Microsoft
Microsoft

@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.

@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

@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.

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.