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" ?

View solution in original post

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors