Forum Discussion

aogland's avatar
aogland
New Member
9 years ago

Issue connecting Power BI Desktop to IBM DB2 database

I am not able to connect my Power BI Desktop to a IBM DB2 database. If I only add the server name and database I get an "Microsoft Db2 Client: No connection could be made because the target machine ...
Anonymous's avatar
Anonymous
Not applicable
7 years ago

I also have the same problem with connection to DB2 from PBI.

 

Using Microsoft driver:

Details: "Microsoft Db2 Client: No connection could be made because the target machine actively refused it xxx.xxx.xxx.xxx:xxxx SQLSTATE=08S01 SQLCODE=-1037"

 

Using IBM driver:

Communication protocol being used: "TCP/IP".  Communication API being used: "SOCKETS".

 

I have tried to connect trough Microsoft Excel with success. Have anyone found a solution for this?

  • BjoernSchaefer's avatar
    BjoernSchaefer
    Helper II
    7 years ago

    Hey Anonymous and everybody else in this thread. 

     

    For me, it works for nearly a year. I'm using the MS-Driver. Important is, that i have to use Port 446, for whatever reason. The other thing is, that PBI Desktop is having a hard time, since the December '18-Update, to refresh Tables from IBM DB2 Databases. The refresh takes, like, forever. Right now, I'm running a refresh for 6 (!) hours. I already opened a Support-Ticket and will keep you up to date in this Thread.

     

    https://community.powerbi.com/t5/Issues/Slow-DB2-refresh-Power-BI-Desktop/idi-p/602152

     

    Regards

     

    BjoernSchaefer

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I know this thread is a year old, but I'm experiencing the same issue. Did anyone have any luck fixing this issue? I've uninstalled, rebooted, reinstalled, rebooted, jumped on one leg...nothing works.

       

      Anyone?

      • Nonsensely's avatar
        Nonsensely
        Advocate I
        6 years ago

        I updated to the latest version of Power BI desktop (version from 4/23/2020) and can no longer connect to my iSeries data.  Dead in the water here, since working on dashboards is my entire work at home life right now.  Also, the Edit Queries option is GONE from this version, so am forced to create new data sources versus editing an SQL statement in the original queries to speed up refresh. 

         

        Super frustrating!  First the new gateway version is throwing bogus errors, now this?  What happened to Microsoft testing before rolling out updates?!!!

    • MzumO's avatar
      MzumO
      Regular Visitor
      2 years ago

      Hey Bjoern,

       

      thanks a lot. The Port 446 solved the issue for me :-).

       

      Kind regards,

      Marco

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      This worked for me as well.  Unfortunately it is horrendously slow for me as well.  About 10 minutes for a million records.  Any ideas here?