on 09 Jun 2016 18:47:02
Enable Direct Query for IBM DB2 data
- Comments (17)
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
RE: Direct query for db2
It's 2019, and this idea is still not done 3 years later. What are the odds?
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?
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.
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
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.
RE: Direct query for db2
This would be a huge feature for my organization!
RE: Direct query for db2
We need this as well !!!!!!
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.
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