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 ...
BjoernSchaefer's avatar
BjoernSchaefer
Icon for Helper II rankHelper 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?