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
v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi jcamilo1985 

 

Do you try to connect to the SSAS server with Power BI Desktop on the same computer as when connecting with Excel? From your screenshots, the only difference is that the second connection has provided the port number of the instance. How about removing the port number and connecting again? And ensure that the SSAS instance is running when you connect. 

 

In addition, you can use PowerShell on your computer to test the connection to the server where the SSAS instance is running. Test-NetConnection (NetTCPIP) | Microsoft Learn

Test-NetConnection -ComputerName "cubos.sispro.gov.co" -Port 2383

 

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

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