Forum Discussion
Get Data with connection to Oracle Database face errors
Hi hpppppp1206 ,
Verify that the registry settings are correct. Ensure that the Oracle client is properly registered in the Windows registry.
Also see if the following similar solution helps.
Solved: Re: "No ODAC driver is found on the System" after ... - Microsoft Fabric Community
Best Regards,
Adamk Kong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Based on the solutions you paste, I have verified from my end for the suggested solution from the comments.
You need to install the latest version of "Oracle-Client-For-Microsoft".
-- I have installed
I downloaded the x64 version, ran the installer and the only thing I changed was the second file path where it asks to point to tnsnames.ora/sqlnet.ora. Gave it the correct file path to my TNS folder and that was it.
-- I also place the correct path that carrying the tnsnames.ora file for connection to database
I also ensure both Power BI desktop app and the OCMT are 64-bit.
My Power BI Desktop Session Diagnostics:
Feedback Type:
Frown (Error)
Timestamp:
2024-08-19T05:30:26.4790955Z
Local Time:
2024-08-19T13:30:26.4790955+08:00
Session ID:
e680d22c-dc5b-4322-9456-5b05b266ff74
Release:
July 2024
Product Version:
2.131.1203.0 (24.07) (x64)
OS Version:
Microsoft Windows NT 10.0.22631.0 (x64 en-US)
CLR Version:
4.8 or later [Release Number = 533320]
Peak Virtual Memory:
71.5 GB
Private Memory:
772 MB
Peak Working Set:
1.14 GB
IE Version:
11.1.22621.0
Model Default Mode:
Import
Model Version:
PowerBI_V3