Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now

Reply
samihuq
Helper III
Helper III

Issue with Oracle Connectivity

‎02-12-2017 11:05 PM

Hi,

Up untill yesterday i could import data from Oracle Database. Last day i downlaoded the new PowerBI Desktop Update and since then i am receiving the bellow error everytime i am trying to connect.

 

Details: "An error happened while reading data from the provider: 'Object reference not set to an instance of an object.'"

 

Note: I am now connecting PowerBI from a different pc that has previous build, currently afraid of upgraing it, please advice as we are trying to go for production this week!!

 

Warm Regards,

Sami

Message 1 of 7
23,402 Views
6 REPLIES 6
Anonymous
Not applicable

‎02-14-2018 09:19 AM

I am having this same issue.PowerBIOracleError.png

 

I can reproduce this issue which seems like a permission issue to the oracle drivers via the Power BI Desktop client. If I change the permission of the application/folders it resolves this issue. However, I do not know how to correctly fix this permission problem without breaking the windows store Power BI App. 

 

I aslo, tried to debug the exe in visual studio, when I run the app in debug mode it doesn't have the issue.  I hope Microsft will fix this issue.

 

Thanks in advance!

Message 7 of 7
22,249 Views
0
v-qiuyu-msft
Community Support
Community Support

‎02-13-2017 06:19 PM

Hi @samihuq,

 

Please verify you have installed the Oracle client software properly according to this article: Installing the Oracle client.

 

Also you can check this similar thread: PowerBI desktop 64Bit oracle connection error Object reference not set to an instance of an object.

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 7
23,386 Views
0
Anonymous
Not applicable
In response to v-qiuyu-msft

‎02-20-2018 07:45 AM

Should I go ahead with a ticket on this issue? I haven't seen a response.

Message 3 of 7
22,229 Views
0
samihuq
Helper III
Helper III
In response to Anonymous

‎02-21-2018 08:56 PM

Sorry for belated responds. Please go ahead and close the ticket as i have moved away from Oracle Database to SQL Server.

Message 4 of 7
22,210 Views
0
anitaberg
Helper I
Helper I
In response to samihuq

‎05-28-2018 02:09 AM

Hi! How did you change the permissions to get this work? I have the same issue, where I installed ODAC into an existing client_1 as I have set up a test environment of Oracle database, and OBIEE Oracle BI, I had already another istance.

 

I have seen other threads about this error message saying it is mixing of 32 bit and 64 bit clients.

Message 5 of 7
21,922 Views
0
Anonymous
Not applicable
In response to anitaberg

‎05-06-2019 09:54 AM

I had the same issue, Restarting Power BI to run as administrator resolves the issue.

Message 6 of 7
21,004 Views

Helpful resources

Announcements
New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.

Join our Fabric User Panel

Join our Fabric User Panel

Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.

March Power BI Update Carousel

Power BI Community Update - March 2026

Check out the March 2026 Power BI update to learn about new features.

View All