Forum Discussion
Solved
Having issues with Connect to Oracle database
Hi ALL, I am trying to connect to oracle database from Power BI Desktop(PBID), but it is throwing below error. Unable to connect we encountered an error while trying to connect Detail...
- You need the latest ODP.net library to use Oracle. Please download it here:http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
You need the latest ODP.net library to use Oracle. Please download it here:http://www.oracle.com/technetwork/topics/dotnet/utilsoft-086879.html
this solution alone was not enough to fix this problem - had to combine the accepted solution with the comment from "gusdcruz" to fix this problem For multiple users in my organisation, the solution was to :
1. Download and install latest ODAC from oracle as listed (in my case was no need to uninstall prev version)
2. Uninstall all Power BI application/s installed via MS Store previously
3. Go to https://powerbi.microsoft.com/en-us/downloads/ , choose Advanced download options(do NOT install via MS Store!) , then download x64/x86 as applicable and install
4. Error fixed!