Forum Discussion
Power BI Direct query connection to IBM DB2
Hi,
I am trying to connect Power BI with IBM DB2 for Direct Query. The required driver has been installed but it still cannot connect to IBM DB2 server. When I tried to connect with Microsoft .Net Framework, it couldn't connect as well. I checked in the command prompt, and it shows .net framework 4.8 is being installed wherein, 4.5 or higher verison is required. Can anyone please help me on this?
Thanks & Regards
Somnath
Hi Anonymous ,
Please change the options of Advanced settings and try again.
Anonymous
It's look like different details in Service and Desktop.
Note:- Use same details in all layers (Power BI Desktop, Service, Gateway).
Please try to re-pro the issue with the correct details and let us know if you have any concerns.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?Thank you everyone for their help. I got so many inputs from you guys. Actually, the problem is with the port number. You can connect with the default port number 446. Make sure you use Microsoft Driver with 4.5 version or higher(I checked mine through CMD; and it is 4.8). The IBM driver will not work(For me, anyways it didn't work) as it will show a licensing problem. Mix storage mode(i.e both Import and DirectQuery) will work fine. Most importantly, update Power BI desktop. I don't know, but I updated and it worked.Take a look at the screenshots below:-
Thanks and Regards
Somnath Bhattacharya
8 Replies
v-frfei-msftCommunity Support
Hi Anonymous ,
Please change the options of Advanced settings and try again.
Hi,
Thank you so much. Will try and let you know.
Thanks & Regards
Somnath Bhattacharya
Can you help me with the Get data IBM DB2 connection as well? I mean get data-> IBM DB2 Database-> Direct Query option. This is not connecting as well.
Or, the connection setting to DB2 only works through Gateway.
Thanking You,
Thanks & Regards
Somnath Bhattacharya
venalMemorable Member
Anonymous
It's look like different details in Service and Desktop.
Note:- Use same details in all layers (Power BI Desktop, Service, Gateway).
Please try to re-pro the issue with the correct details and let us know if you have any concerns.
If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?Thank you everyone for their help. I got so many inputs from you guys. Actually, the problem is with the port number. You can connect with the default port number 446. Make sure you use Microsoft Driver with 4.5 version or higher(I checked mine through CMD; and it is 4.8). The IBM driver will not work(For me, anyways it didn't work) as it will show a licensing problem. Mix storage mode(i.e both Import and DirectQuery) will work fine. Most importantly, update Power BI desktop. I don't know, but I updated and it worked.Take a look at the screenshots below:-
Thanks and Regards
Somnath Bhattacharya
Anonymous Can you please help me to get the connection working for DB2 from Power BI. I have the hostname, password, port number etc. I could see we need to use 446 always. What other details I should request from DB2 team? Please can you connect to me offline at [email protected] as I would need urgent help on this for a client POC to be done soon. Appreciate your help. v-frfei-msft Please can you provide your inputs as well. I am getting the error - "Microsoft Db2 Client: A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond