Forum Discussion

aogland's avatar
aogland
New Member
9 years ago

Issue connecting Power BI Desktop to IBM DB2 database

I am not able to connect my Power BI Desktop to a IBM DB2 database. If I only add the server name and database I get an "Microsoft Db2 Client: No connection could be made because the target machine ...
muchinski's avatar
muchinski
Icon for Resolver II rankResolver II
3 years ago

For the error "DB2: We were unable to find a database provider with invariant name 'IBM.Data.DB2'", can you try to uninstall the IBM Driver and reinstall it?

BUT at this time, use "Run as administrator" when runing the installer.

Also, be sure to download the 64-bit version!

Afte that, please check If the Driver was installed corretly:

[System.Data.Common.DbProviderFactories]::GetFactoryClasses() | ogv

It should return something like that:

 

 

(I had the same error and it solved for me)