Forum Discussion

dramus's avatar
dramus
Continued 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
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.

IncrementalValu's avatar
IncrementalValu
New Member
2 years ago

I was still geting the error, even when utilizing quotes. i.e.

 

 

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

 

 

 
I instead used a variable to define the current path of Oracle.DataAccess.dll and then used that which seemed to work:

 

 

set oracle19cprovider="C:\oracle\ora19c64\client\ODP.NET\bin\4"
OraProvCfg.exe /action:gac /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'
OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'

 

*Note, your location of Oracle.DataAccess.dll may be different than what I am using.