Forum Discussion
Post PatronIBM DB2 Connection
I recently had to help a group of clients connect, and we found that the following conditions were necessary:
1) You must have the DB2 client installed on the machine from which you are trying to connect
2) Under Advanced Options in the Power BI connection dialog:
a) You have to use the Microsoft driver (as you mention)
b) You have to uncheck the "Navigate Using Full Hierarchy" option
3) You need to connect using the Database tab (not the Windows tab) and use your MF credentials
Without all of these in place, we had to use ODBC to connect.
FWIW, the view provided form the MF was basically just a selection of tables -- no individual columns were selectable.
Post PatronThank you for the response Anonymous. I do not specify any specific SQL statements when trying to connect to the IBM DB2 database. And I do not understand the content of the article you referred me to.
Interestingly, the connection over ODBC does actually work but performance is unusuably slow (such as when I filter a column for example).
I've emailed the log files to [email protected]
I am an administrator for DB2 on Z/OS trying to support a Power BI desk-top user having the same problem. The user sees a -805 error returned to his session, however, this error is not taking place on Z/OS. The connection was never made. I believe the package that needs to be bound is for the data provider to support the connect request. At this time we are stuck because we don't konw what package to bind.
I'm getting the same problem. It works on one DB2 System which has the Package MSCS001 Bound. Can I download MSCS001 from Microsoft somewhere and Bind MSCS001 on the system I need Power BI access to?