OCIEnvCreate failed

[shekhar103]

Not able to connect Oracle db with Power BI given below error comes - 

Details: "The provider being used is deprecated: 'OCIEnvCreate failed with return code -1 but error message text was not available.'. 

Please help me to resolve the above gven error. 

[v-yuezhe-msft]

@shekhar103,

Please update your Oracle client to  the latest version following the guide in the article below.
https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

Regards,
Lydia

[shekhar103]

I am trying to install ODAC122010 but  not able to install properly getting the given below error at the time of installation - 

Oracle Client Configuration  - Failed

•     Oracle Services for Microsoft Transaction Server    - Failed

Please help me to relsolve the above given error

Thanks

[v-yuezhe-msft]

@shekhar103,

Please check if the solution in this similar thread works in your case, and I would recommend you post the question in Oracle forum to get better support.

Regards,
Lydia