Forum Discussion
Oracle connection error: Object reference not set to an instance
Hi I'm trying to connect to an Oracle 11g database (not local), but I do only receive an error message. First I write in the servername/ip-address/tnsnames on the Oracle server and then I'm displ...
If you are using the Marketplace version of Power Bi Desktop and getting this error, try this:
In your oracle client home directory you should be able to find oraons.dll. Copy this file into the \bin folder of the same directory.
Close any open Power BI Desktop and reopen it.
You should be able to connect now.
This worked for me. I found it buried in the install instructions for Oracle on Power BI on Microsofts site.
For me the directory where I found the file was:
c:\app\client\OraHome
and I copied it to
c:\app\client\OraHome\bin
Hope this helps somebody!
Oh my goodness, you just saved my whole day. I was so flustered trying to figure out what broke.