cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MrBIn
Frequent Visitor

Error message when trying to connect to a Oracle Database

I'm trying to connect to an on-premise Oracle database.

 

Oracle Power BI.png

Sorry that the error message is in German, the English translation would be: 

An error occurred while establishing a connection.

Details: "Error when reading data from the provider: "The object reference was not set to an object instance""

 

I followed all the steps from the offficial documentation (Connect to an Oracle database with Power BI Desktop - Power BI | Microsoft Docs) as well as the steps from this tutorial: https://www.youtube.com/watch?v=ClBQ3_p7T_A . Oracle Access Client is installed as well.

 

I entered the server adress accordingly (host:port/SID) and then got asked to put in the database login data.

After this step, the error occurs. I can't really identify the source of the problem. Are my credentials wrong? Or did I miss some steps inbetween? Not really sure what to do with this error message. 

 

Any help would be appreciated!

3 REPLIES 3
v-jayw-msft
Community Support
Community Support

Hi @MrBIn ,

 

You may check if the solutions in the following similar threads help.

https://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-refere...

https://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-refere...

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
amitchandak
Super User
Super User

@MrBIn , there is one solution in the description of the problem

https://community.powerbi.com/t5/Desktop/Getting-Power-BI-Desktop-to-work-with-Oracle-ODAC-AFTER-ver...

 

Few links below.

 

if needed add the oracle diver installation folder path into windows environment path

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!

Hello @amitchandak , thanks for your answer.

 

I did all the steps listed in the provided link, unfortunately I still get the same error message.

 

What exactly do you mean with "if needed add the oracle diver installation folder path into windows environment path"?


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.