Forum Discussion
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 after the load tables.
Note: I'm using same host,port,sid values and same database credential for two type of connection.
PBI Desktop Version: 2.86.902.0 64-bit
Oracle Client Version : 19c 64 bit
Here's the error message:
Cannot Load Model
We couldn't connect to your Direct Query data source or internal model.Double-check that your server and database names are correct, and that you have permission to access them.
The managed provider 'Oracle.DataAccess.Client' could not be instantiated.
Please, could you help me ?
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.
5 Replies
fince94 , In the case of oracle you need to provide the path of the driver in the environment path variable of Oracle.
Make sure you have done that
Hello,
I defined path of odp.net but it didnt be solution for me.
Thank you.
Hi fince94 ,
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-not-working/td-p/721568
Did I answer your question ? Please mark my reply as solution. Thank you very much.
Best Regards,
Eyelyn QinHi,
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-bitOracle database version : 19c
I tried ODAC 122011 - 64 BitAlso I have to use VPN for connect database.
Regards.
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.
