Skip to main content

    Power BI

    New

    Direct query for db2

    Vote (55) Share
    's profile image

    on 09 Jun 2016 18:47:02

    Enable Direct Query for IBM DB2 data

    Comments (17)
    's profile image Profile Picture

    d5a1daec 3f7d-4ce5-bfb0-46fd14eb7324 on 06 Jul 2020 00:03:04

    RE: Direct query for db2

    When I am trying to connect to IBM DB2, I am getting the error that No such host is known. Microsoft DB2 Client: No such host is known. SQLSTATE = 08S01 SQL CODE = -1336

    's profile image Profile Picture

    87b07d1a e873-47d3-a32f-3e5510b81dea on 05 Jul 2020 23:52:05

    RE: Direct query for db2

    It's 2019, and this idea is still not done 3 years later. What are the odds?

    's profile image Profile Picture

    cf76438b eb68-4ce6-b13d-d9ee13d0bb8d on 05 Jul 2020 23:27:36

    RE: Direct query for db2

    I'm able to use the "import" option for a Db2 database, but I'm getting an unexpected error "Couldn't load the model schema" in the "directquery" mode. In the directquery mode, I'm able to see data in the query editor, but when I "close and apply" from the query editor, I get the error message and the dataset does not appear in the "fields" menu at the right-hand side of the page. Is anyone else having issues with directquery but are able to use import?

    's profile image Profile Picture

    0035e8ce e927-4edc-9420-92e7e91a094c on 05 Jul 2020 23:27:17

    RE: Direct query for db2

    In the Power BI desktop July release this is a Preview feature, but I cant find any information about it.

    's profile image Profile Picture

    c21e528f 58d1-46f8-9ec3-2b4588af5c97 on 05 Jul 2020 23:24:57

    RE: Direct query for db2

    what kind of product is it in terms of lincencing, security.... Does it require storing data on the cloud ? thanks

    's profile image Profile Picture

    10c67f13 4d74-4762-9f8d-a5e6b08311f2 on 05 Jul 2020 23:24:17

    RE: Direct query for db2

    If anyone is interested in trying out Conduit - https://bpcs.com/conduit , which enables direct query for DB2 (until PowerBI adds support natively), I'd be happy to get you set up. Let me know.

    's profile image Profile Picture

    de1e6f64 56cd-4f90-9a12-580420b3df80 on 05 Jul 2020 23:24:13

    RE: Direct query for db2

    This would be a huge feature for my organization!

    's profile image Profile Picture

    95697da6 d228-4cea-8c68-5914914d0c3d on 05 Jul 2020 23:21:00

    RE: Direct query for db2

    We need this as well !!!!!!

    's profile image Profile Picture

    ef6444c5 7184-4abc-9415-6e3f4292a047 on 05 Jul 2020 23:18:39

    RE: Direct query for db2

    A possible workaround, if you have a sql server, would be to add db2 as a linked server. Then create a sql server database. Then create views to query the db2 tables. A caveat is performance. The linked server queries are slow.

    's profile image Profile Picture

    c21e528f 58d1-46f8-9ec3-2b4588af5c97 on 05 Jul 2020 23:18:37

    RE: Direct query for db2

    Is this planned for the near future. our company decision will be influenced by the lack of this option in DB2