Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 .Ne...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    Please change the options of Advanced settings and try again.

     

     

     

  • venal's avatar
    venal
    6 years ago

    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?

     

  • Anonymous's avatar
    Anonymous
    6 years ago

    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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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