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

Connect Power BI to Oracle DB

Hi,

 

I'm trying to connect to Oracle DB. I already installed connector, but after I put server name and also the database credential, I got this error.

 

Details: "Object reference not set to an instance of an object."

 

Any idea?

 

Thanks.

Priscilla

1 ACCEPTED SOLUTION
arify
Microsoft
Microsoft

Can you take a look at this thread if it fixes your problem? http://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-referen...

 

Also, can you send us a frown with that exception? Does it say "Unexpected Exception" ?

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Microsoft
Microsoft

Hi @minimynt,

Firstly, please make sure that you use the latest version of Power BI Desktop, and you have installed the latest version of Oracle client following the instructions in this article. Ensure that your Oracle client, Oracle Server and Power BI Desktop have the same bitness(32bit or 64bit).

Secondly, in Power BI Desktop , go to File >Options and Settings > Data Source Settings, delete any Oracle data source, then connect to Oracle via “Get Data>Oracle Database” again.

Thirdly, when connecting to Oracle from Power BI desktop, enter the connection details in TNSnames.ora file, then check if it is successful. Alternatively, you can connect to the Oracle Database via EZConnect connection string. For more details, please review this similar blog.

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
arify
Microsoft
Microsoft

Can you take a look at this thread if it fixes your problem? http://community.powerbi.com/t5/Desktop/PowerBI-desktop-64Bit-oracle-connection-error-Object-referen...

 

Also, can you send us a frown with that exception? Does it say "Unexpected Exception" ?

altieripereira
Regular Visitor

Hi,

 

How version of Power BI you area using ?

@altieripereira Hi, I use Power BI june update 64 bit

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors