Forum Discussion

Dion-NZ's avatar
Dion-NZ
Frequent Visitor
5 years ago

Connecting to a IBM DB2 Data Source

Hi all,   The company I work for has some data stored with a third party that is using a IBM DB2 database, and I'm hoping to get that data imported into my Power BI reports. I also want them connec...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
5 years ago

Hi Dion-NZ ,

If you cannot connect to IBM DB2 in power bi desktop, please make sure the instance is running on the server. TCP /IP services are started on remote DB2 server. Port number is correct and it's open on server.

You can refer this simliar issue:

Issue connecting Power BI Desktop to IBM DB2 database 

 

If you want to connect it by ODBC, you can refer these documents which introdcues it in details:

  1. Connecting to IBM DB2 for i (ODBC) 
  2. Configuring a DB2 ODBC Data Source Name 

 

In addition, when you have any new error codes during debugging, you can refer to this document to check:

SQL error codes- IBM 

 

 

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.