Forum Discussion
Error connecting to Oracle Object reference not set to an instance of an obj
Hi friedcc
Turns out the latest (Sep 2018) version of PBI has this issue if it is downloaded from the Microsoft Store. If it is downloaded from the download webpage, it works with Oracle just fine. So... DO NOT USE the Microsoft Store to install Power BI.
It seems you have solved problem by yourself, thans for sharing here.
Best Regards
Maggie
I'm also having the same error (Object reference not set to an instance of an object) on my Oracle personal gateway when trying to refresh pbix files that I created prior to upgrading to the October release. I have no issues if I create a brand new pbix file and query on the October release.
I uninstalled the October release and re-installed the September release. Now all my pbix files with Oracle data refresh correctly.
Any updates if this is a bug in the connector or how to resolve the error?
Hi
I raised a ticket with MS on this and got it solved.
We were not seeing the error when we manually downloaded and installed PBI. Our default is the MS Store for our users and thats where we saw the same error.
I got a workaround today from MS that I have confirmed is working for the Nov/Dec 2018 MS Store release.
1. Locate and copy the oraons.dll file in ‘<<ORACLE_CLIENT_INSTALL>>product\12.2.0\client_1’ on your oracle install path
2. Paste the file into the ‘<<ORACLE_CLIENT_INSTALL>>product\12.2.0\client_1\bin directory
3. Fire up PBI and get some Oracle data.
The reason is, that the MS Store version of PBI looks in very specific directories for dlls, then to driver registry settings. The Oracle registry setting is not poiinting to the correct directory for the oraons.dll >>> error! I guess you could correct the registry setting but thats not an option for us and would prolly break the Oracle Client for other uses ... ugh!
Cheers
Tim