Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I've been tying to create a gateway to connect to a cube from SSAS but I cant, this is the problem
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.
@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
@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:
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
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