Forum Discussion

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
5 years ago

Getting Power BI Desktop to work with Oracle ODAC AFTER version 12.2

Power BI Desktop needs the Oracle data providers installed at the machine level. After ODAC 12.2, Oracle removed this option from the install, which means out of the box Oracle 18.x and 19.x ODAC ins...
Tips and Tricks
dramirezkon's avatar
dramirezkon
Frequent Visitor
3 years ago

Hi, I'm trying to config but when I run 

OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll​

showme this error:

C:\oracle\odp.net\bin\4>OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll​
ERROR: File not found: oracle.dataaccess.dll?
Error: Referencia a objeto no establecida como instancia de un objeto.

 

Can you help me? 

NathanMarston's avatar
NathanMarston
New Member
3 years ago

I ran into the same error - what i found I had to do was put quotes around "Oracle.DataAccess.dll", exactly like he did with the first call to OraProvCfg.