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 idea is to pass this connection to power bi, to a data flow, or to a datamart.

However, when it is done from power bi, it cannot connect, considering that power bi is a more up-to-date tool than excel, I do not understand why I cannot establish the connection.

Any guidance will be appreciated

I annex screenshots of the connection path

 

Need Help

4 Replies

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