Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |