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 ...
robarivas's avatar
robarivas
Post Patron
9 years ago

Hello aogland, v-sihou-msft, and Greg_Deckler

 

I still cannot get the connection to work. Anyone have any idea what I might be doing wrong?? I've installed the IBM Data Server Driver Package software and I've specified the correct server and port and database name. What else am I supposed to do?

 

I keep getting the following error using the IBM driver:

     We were unable to find a database provider with invariant name 'IBM.Data.DB2'

 

Using the MIcrosoft driver I get:

   The package corresponding to an SQL statement execution request was not found. SQLSTATE=51002 SQLCODE=-805

aogland's avatar
aogland
New Member
9 years ago

I still have not got it to work.

  • dmontella's avatar
    dmontella
    New Member
    9 years ago

    Same exacct issue when connecting to DB2 from Power BI:

     

    Details: "IBM DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'.
    This error could've been the result of provider-specific client software being required, but missing on this computer.  To download client software for this provider, visit the following site and choose the 64-bit (x64) version of, at minimum, 'IBM Data Server Driver Package (DS Driver)': https://go.microsoft.com/fwlink/p/?LinkID=274911"

    • ahilansinn's avatar
      ahilansinn
      New Member
      7 years ago

      Running into the same issues. Can anyone else here?