Forum Discussion

Frequent Visitor

5 years ago

Solved

Retrieving Data Problem With Direct Query From Oracle Database

Hello, I can successfully get data from oracle database with import connection mode. But when ı am using direct query mode for connect to same oracle database with same credentials ı get error a...

fince94
5 years ago
Hello, in my case when ı installed 32 bit oracle version 11.2.0 and 32 bit power bi to virtual machine (not my local machine) and the problem has gone.

Anonymous

Not applicable

5 years ago

It seems to be related to the version of Oracle, please take a look at these cases for reference.

https://community.powerbi.com/t5/Desktop/Oracle-DataAccess-Client-direct-query-error/td-p/757448

https://community.powerbi.com/t5/Desktop/Direct-Query-is-not-working-while-Connecting-to-Oracle-database/td-p/326006

https://community.powerbi.com/t5/Desktop/Direct-Query-not-working/td-p/721568

Did I answer your question ? Please mark my reply as solution. Thank you very much.

Best Regards,
Eyelyn Qin

Frequent Visitor

5 years ago

Hi,

Thank you for your helping but ı tried everything and the problem is still exist.
Here's some info:
My power bi version: 2.86.902.0 64-bit

Oracle database version : 19c
I tried ODAC 122011 - 64 Bit

Also I have to use VPN for connect database.

Regards.