Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 ?
Solved! Go to Solution.
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.
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.
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 Qin
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.
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |