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

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.

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

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Top Kudoed Authors
Users Online
Currently online: 47 members 1,021 guests
Please welcome our newest community members: