Get Data with connection to Oracle Database face errors

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

Hi Adam,

I have verified the suggestion solutions from comments under your shared link.

> 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 did this, pointed the path to my tnsnames.ora for database conn.

I also ensured both Power BI Desktop and OCMT are latest and 64bits.

I also tried uninstall client tool and reinstall. It seems doesn't help.

I still facing "No ODAC driver is found on the System".