Forum Discussion
Unable to connect with Oracle DB from Power BI -Recommended data provider oracle.dataAccess.Client
Dear Team, Firstly since we are in genAI age, I did took help from Copilot /gemini /previous post on same issue ,but could not fix When i try to get data from oracle i am getting Error in scree...
Hi lbendlin CAn you pls tell me what is the link of native oracle driver .
I have installed oracle instant client & odbc driver as well already
in the client i have configured the tnsname.ora file
and then the path of that file is mentioned in TNS_ADMIN system environment variable
TNS_ADMIN : C:\Users\xxx_yyy\instantclient_21_13\network\admin
Now when i connect using power bi i am still getting same error
Note : i used the tns name
content of tnsnames.ora
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST =blablabutcorrect)(PORT =1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =blablabutcorrect)
)
)
- lbendlin
Super User
That looks better . Try downgrading to v19
