Oracle.DataAccess.Client could not be instantiated

Anonymous · ‎06-13-2019

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:

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

v-yuta-msft · ‎06-13-2019

@Anonymous ,

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

Regards,

Jimmy Tao

Anonymous · ‎06-14-2019

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

Anonymous · ‎06-14-2019

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?

Anonymous · ‎12-14-2022

I am having the same exact problem.
Did you manage to find any solution about it?

Anonymous · ‎06-13-2019

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

Helpful resources