Forum Discussion

dramus's avatar
dramus
Continued 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
Advocate I
3 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
Continued Contributor
3 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?

  • mkcongrove1's avatar
    mkcongrove1
    Advocate I
    3 years ago

    After all the hours spent trying to solve this issue it was my companies rolled out version of PBI Desktop. It was right in the article I had read 100 times but skimmed over because I have PBI desktop pushed to my machine. I had to have IT remote in to install.

     

    If you downloaded Power BI Desktop from the Microsoft Store, you might be unable to connect to Oracle databases because of an Oracle driver issue. If you encounter this issue, the error message returned is: Object reference not set. This is an issue with how Oracle driver works in Windows UWP Apps. To address the issue, you have to do the following:

    • Download Power BI Desktop from the Download Center instead of Microsoft Store.