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?