Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
User | Count |
---|---|
70 | |
70 | |
34 | |
23 | |
22 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |