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 installs are not seen by Power BI Desktop. I've spent the last 24 hours installing and uninstalling various versions of ODAC trying to get them to work with Power BI Desktop.
I'm limiting this to the 64bit install (Because that is what I have) and .NET 4.0, becuase that is what Power BI Desktop needs.
I can now report I have ODAC 19.3 working with Power BI Desktop (May 2021). This is thanks to Google and a lot of digging around. I've put a link to the original article I found that helped me get the data providers installed, as this was not my own work! (Power BI Github comment ), I'm just documenting it here for others.
OraProvCfg.exe /action:gac /providerpath:"Oracle.DataAccess.dll" OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll
7. One last thing, from the main install directory take a copy of the oraons.dll and copy it into the bin directory.
Having done the above I was able to start Power BI Desktop and connect to an Oracle data source.
I am trying this on a laptop w/only Oracle 19c as the client. I did all this, still getting Oracle: ORA-12170: TNS:Connect timeout occurred.
Could this be due to ACL's not on this computer?
My TOAD works though - but it is not using the tnsnames.ora on the laptop.
@dramus Thanks ,
which setup.exe are you talking about?Can you please explain?
@dramus Thanks. I have already downloaded. Please see the below screen shot. I am confused about your STEP 4 which setup.exe we need to RUN under which folder?
In the top level of the folder that you unzipped the download to, there should be 2 folders and 2 files. The 2 files are setup.ini and setup.exe, you need to run the setup.exe file.
@dramus thanks and appreciate your patience, the only contents i see under the exracted files are in the snapshot. I do not see any setup.exe files.
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.