Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Thanks bro!
I was two days trying to put a dashboard to work in a vm
Did you have to run these as well?
OraProvCfg.exe /action:gac /providerpath:"Oracle.DataAccess.dll"
OraProvCfg /action:config /force /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319 /providerpath:Oracle.DataAccess.dll
I'm not sure.
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?
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.
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.
Can you please let me know the steps to uninstall an older version of ODAC?
To uninstall a version of ODAC. I haven't run this, but it should be close.
OraProvCfg.exe /action:ungac /providerpath:"Oracle.DataAccess.dll"
OraProvCfg /action:unconfig /product:odp /component:dbproviderfactory /frameworkversion:v4.0.30319
I made a slight change but overall it works well, thank you!
set oracle19cprovider="C:\oracle\ora19c64\client\ODP.NET\bin\4"
OraProvCfg.exe /action:ungac /providerpath:'%oracle19cprovider%\Oracle.DataAccess.dll'
OraProvCfg /action:unconfig /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.
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.
Were you ever able to solve this issue? Could you share your solution if so? I have been stuck here for months now 😞
Check your Windows environment variables. Is the Oracle client you are trying to use the first oracle path in the PATH variable? Do you have TNS_ADMIN defined and pointing to a valid tnsnames.ora directory?
If use go to a command prompt and type tnsping <your oracle tnsnames entry>, does it ping correctly?
After all the hours spent trying to solve this issue it was my companies rolled out version of PBI Desktop. It was right in the article I had read 100 times but skimmed over because I have PBI desktop pushed to my machine. I had to have IT remote in to install.
If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is: Object reference not set. This is an issue with how Oracle driver works in Windows UWP Apps. To address the issue, you have to do the following:
I got a brand new laptop with a brand new install of Oracle desktop client.
@dramus Thanks ,
which setup.exe are you talking about?Can you please explain?
Thanks
The ODAC installer. https://www.oracle.com/database/technologies/dotnet-odacdeploy-downloads.html
@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?
Thanks
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.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
81 | |
70 | |
49 |
User | Count |
---|---|
143 | |
124 | |
107 | |
60 | |
55 |