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.

Answer 1

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.

Answer 2

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

2. Paste the file into the ‘<>product\12.2.0\client_1\bin directory

Answer 3

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

Answer 4

I'm having the same error but when trying to connect into a CentOS 8 MariaDB 10.4, have no clue what I must do to make it work.( I already created a user to access remotely and port is open on Firewall)

I'm trying to connect from PowerBI Desktop 2.79.5768.1082 64-bit (March 2020)

If someone know how I can achieve this, would be great.

Answer 5

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: