Oracle connection error: Object reference not set to an instance

Thank you! I had the same error ("Object reference not set to an instance").

In my case it didn't work with Power BI downloaded from Microsoft Store either.

I was googling hard but couln't find any download link or then I was redirected to the store. I usually had the web version downloaded but this options seems to be removed for updating. So thanks for the link!

For the record and people having the same troubles I had:

I was using Power BI from the Microsoft Store and was trying to connect to an oracle database.

However, I had the error "The recommended provider ('Oracle.DataAccess.Client') is not installed."

So I can confirm:
- download ODAC121024_x64.zip from https://www.oracle.com/technetwork/database/windows/downloads/index-090165.html (64bit in my case)

- unzip and run the setup.exe (I had it run with default settings)

- Then, if you are able to connect but get the object reference error, deinstall Power BI Microsoft Store version, download from the web and run this version.

- trying to connect again to my oracle database. What a surprise, it worked!

Best,

Trojii