Anonymous's avatar
Anonymous
Not applicable
7 years ago
Status:
New

DB2 support - Default driver not working

When choosing IBM DB2 database as data source, nothing works until we go under Advanced Options and choose IBM as the driver instead of Microsoft.  It should default to a working driver without the u...
Data Modeling
DanielAdler's avatar
DanielAdler
Frequent Visitor
7 years ago

I experience the same problem and it seems to occur when Micorosfts DB2 OLEDB driver is installed on the same system as Power BI Desktop.

 

On my system when I install the driver DB2OLEDBV6_x64 and try to connect to the DB2 database with Power BI Desktop I get the error Details: "An error happened while reading data from the provider: 'The type initializer for 'Microsoft.HostIntegration.Common.TelemetryCLient' threw an exception.'"

 

When I uninstall the driver, The default .NET DB2-driver in Power BI Desktop works as a charm.

 

Googling for Type Initializer errors suggests there is some kind of mismatch between versions of .NET between the drivers and that the DB2OLEDB-driver imposes something that makes Power BI Desktop to load mismatching versions of code.

 

Also, this affects Power BI Report Server as well which suggests it is on an driver installation level.

 

Anonymousand v-qiuyu-msft : Great if you could try this out.

 

Best regards,

Daniel

 

Completed Ideas