I am trying to set up data source for IBM DB2 on Power BI service and encounter above error message.
Doing the same on PBI desktop using Microsoft driver yield the same error. However, using IBM driver on PBI desktop works well.
The problem is that I am unable to indicate to use IBM driver on PBI service via the gateway and I suppose the data source on PBI service is configure to use Microsoft driver. I checked, I have .Net 4.7 and the latest PBI desktop.
Please advise me if you have clues to resolve this issue. Thanks!
I have tested with the Microsoft Driver successfully. The coincidence is that I have the exact .net 4.5. Is this the cause? If it's possible for you to swich to .Net 4.5 for test?
Thanks for your reply.
I cannot figure out a way to switch back to .Net 4.5, seems to come default with windows 10.
My data gateway is installed on machine A and DB2 is on machine B. Do both machines require .Net 4.5 or only machine A?
Does the version of DB2 matter? https://docs.microsoft.com/en-us/power-bi/desktop-data-source-prerequisites
I'm afraid the version of DB2 matters. Do you have the older one?
I just realized my DB2 .NET data provider version is 9.7. Below mention need at least 10.1. I will work on getting the upgraded IBM Data Server Driver. Thanks.
After some investigation, I realized that using Microsoft driver for IBM DB2 datasource, I can connect to the databases under the default instance, but not databases under the other instances. Have you tried connecting to databases under non-default instance using Microsoft driver?
The secret could be in the connect string. Maybe it's something like it in the SQL Server: ServerName\Instance. Please try out a different string for the Server. Related documents: Configuring access to DB2 databases and Designing instances.
Thanks for your reply. I briefly tried but cannot seem to make it work. But I manage to work around by just using ODBC. Thanks!