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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Anonymous
Not applicable

@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

@Anonymous,

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

Anonymous
Not applicable

@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

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

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.