Power BI Direct query connection to IBM DB2

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