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

Oracle.DataAccess.Client could not be instantiated

Hello,

 

I started working with Power BI Desktop couple days ago. My data source is Oracle DB.

I'm usiong Power BI Desktop x64 and I installed 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64.

I connected to my Oracle and created basic model. I used DirectQuery as Storage options. Everything seems to be ok, when I'm creating a model.

But... when I saved it and tried to open it again it doesn't work at all. I receive an error:PBIError.png

When I'm connecting to Oracle DB and trying to add new tables I also receive this error mesaage.

I'm even more confised because when creating new document from scratch it works.

 

Could you please help me?

 

Best regards,

Szymon

 

 

4 REPLIES 4
boskiSzymciu Frequent Visitor
Frequent Visitor

Re: Oracle.DataAccess.Client could not be instantiated

Hi, do you have any idea what can be wrong?

Community Support Team
Community Support Team

Re: Oracle.DataAccess.Client could not be instantiated

@boskiSzymciu ,

 

Please refer to the similar thread in exchange forumn, this issue should be related to the ODAC Driver.

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=0ac479ec-...

 

Regards,

Jimmy Tao

boskiSzymciu Frequent Visitor
Frequent Visitor

Re: Oracle.DataAccess.Client could not be instantiated

Thank you @v-yuta-msft for your quick response.

I did all steps that are described in the link you pasted. Unfortunately I still have the same problem.

Any other ideas? 😞

boskiSzymciu Frequent Visitor
Frequent Visitor

Re: Oracle.DataAccess.Client could not be instantiated

Moreover I have this kind of error only when I'm using directQuery storage.

When the tables are loaded I can work with them, save my Power BI model, close it down, open once again and it works.

DirectQuery doesn't work. What is wrong? 

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 398 members 3,813 guests