Forum Discussion

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
5 years ago

Getting Power BI Desktop to work with Oracle ODAC AFTER version 12.2

Power BI Desktop needs the Oracle data providers installed at the machine level. After ODAC 12.2, Oracle removed this option from the install, which means out of the box Oracle 18.x and 19.x ODAC ins...
Tips and Tricks
mkcongrove1's avatar
mkcongrove1
Icon for Advocate I rankAdvocate I
4 years ago

Were you ever able to solve this issue? Could you share your solution if so? I have been stuck here for months now 😞

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
4 years ago

Check your Windows environment variables. Is the Oracle client you are trying to use the first oracle path in the PATH variable? Do you have TNS_ADMIN defined and pointing to a valid tnsnames.ora directory?

 

If use go to a command prompt and type tnsping <your oracle tnsnames entry>, does it ping correctly?