Forum Discussion
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
Helper II
Helper IIHey 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
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?