POWERBI - Object reference not set to an instance of an object

Question

I'm trying to connect oracle database using prowerbi desktop. Throwing following error

Details: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"

Any idea why i see this error? I have searched it before posting here and found no clue.

score 23 · Answer 1 · answered Jan 24 '19 at 14:19

23

Locate and copy the oraons.dll file in ‘<>product\12.2.0\client_1’ on your oracle install path
Paste the file into the ‘<>product\12.2.0\client_1\bin directory

answered Jan 24 '19 at 14:19

Mayur Bhardwaj

231
2
2

Works for me, thanks. how did you find this solution? and why? – IanJay Jun 23 '20 at 03:51
FYI: This fix is mentioned on the official PowerBI site: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#troubleshooting – David Oct 11 '20 at 15:00
2

The fix info has been removed from the Official PowerBI documentation. However, it still works like a charm. Thanks Mayur! – Hatim Stovewala Jan 23 '22 at 12:54
Perfectly worked. Thanks! – Lucas Rezende Nov 09 '22 at 14:50
1

Worked! Thanks! I can't believe we're still having to do this janky fix in late 2022! – grego Dec 02 '22 at 23:35

score 5 · Answer 2 · answered Nov 21 '19 at 10:18

5

In my case, the problem was the version of Power BI, I downloaded and install it from Windows Store and the version place there got a bug.

My solution was to uninstall my PBI, download it from microsoft web page (not from Store) and install it.

https://www.microsoft.com/es-ES/download/details.aspx?id=58494

Once it's done then problem get solve. Regards

answered Nov 21 '19 at 10:18

Angel Quero

51
1
1

1

FYI: This fix is mentioned on the official PowerBI site: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#troubleshooting – David Oct 11 '20 at 15:00
This is so true – Badr Bellaj Aug 31 '21 at 14:33

score 2 · Accepted Answer · answered Jan 05 '18 at 03:28

2

Solved - The issue is because of the versions of Oracle client and Power BI desktop.

Oracle client was 32 bit and Powerbi was 64 bit, after updating oracle client to 64 bit everything works great.

answered Jan 05 '18 at 03:28

Praveen Govind

2,619
2
32
45

score 0 · Answer 4 · answered May 25 '22 at 21:50

I resolved this issue following this instruction from Power BI Desktop troubleshooting reference:

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:

POWERBI - Object reference not set to an instance of an object

4 Answers4