Forum Discussion

jcamilo1985's avatar
jcamilo1985
Helper III
3 years ago

connect power bi analysis services

Good night I have a scenario that has me out of place. I have a connection that is made through excel to analysis services, from excel we have no problems establishing the connection. However, the ...
Need Help
jcamilo1985's avatar
jcamilo1985
Helper III
3 years ago

Good morning.
first thank you very much for the answer v-jingzhang.
Yes, it is the same equipment, for excel the connection is successful, but instead in power bi it fails. I did the test without including the port in the power bi dialog and the result is the same, I can't connect.
when I run the power shell it tells me:

ComputarName: cubos.sispro.gov.co
Remote Address: 181.79.3.29
Remote Port: 2383
InterfaceAlias: Ethernet
SourceAddress: 'my ip'
TcpTestSucceeded: True

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi jcamilo1985 

 

Sorry for the late reply. Maybe you have solved this problem. I just noticed that you were using the Basic authentication type to connect to the SSAS server. This could be a cause of the connection failure. Please use Windows authentication type. This is because SSAS server access is verified by Active Directory so you need to use a windows account to connect to it.  

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.