Oracle.DataAccess.Client could not be instantiated

[Anonymous]

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]

@Anonymous ,

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-35bc-4d73-9c92-48a52f9f43e7&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

Regards,

Jimmy Tao

[Anonymous]

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]

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? 

[sonifb]

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

[Anonymous]

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