Forum Discussion

Hayden_RP's avatar
Hayden_RP
New Member
7 months ago
Solved

Difficulties connecting Oracle SQL Developer to Power BI

Hello, I'm trying to get a project for work running but am very new to Power BI. I receive an error that reads "Details: "Oracle: ORA-12154: TNS:could not resolve the connect identifier specified" ...
Need Help
  • d_m_LNK's avatar
    d_m_LNK
    7 months ago

    Hopefully your local admin can help you get things in the right spot.  For Power BI I believe it has to use the driver for the Microsoft products I specified before and the TSNames file needs to be in that directory as well.  Hopefull your admin can help you get things moved and installed correctly.  

d_m_LNK's avatar
d_m_LNK
Super User
7 months ago

There is a TSNames.ora file in the oracle client install folder that needs to contain the connection information for your server.   Your system admin may have a copy of one to use.

  • Hayden_RP's avatar
    Hayden_RP
    New Member
    7 months ago

    What I'm finding is that I can't seem to find TSNames.ora anywhere even in client folder. I looked in Oracle SQL Developer and it appears as such:


    I think I'm confused in part because I don't know where to get that file in the first place and just need to figure out where to go from here.

     

    • d_m_LNK's avatar
      d_m_LNK
      Super User
      7 months ago

      Your Oracle DB admin should be able to help you with the connection string and/or TSNames.ora file needed to connect

       

      Also for me I downloaded the Oracle Client for Microsoft tools Here: Oracle Client for Microsoft Tools
      This will be used for power BI specifically to connect to the oracle DB

       

      When I installed that the TSNames file will need to be located in the location: C:\Program Files\Oracle Client for Microsoft Tools\network\admin 

       

      This was also a helpful Microsoft article to help: Connect to an Oracle Database with Power BI Desktop - Power BI | Microsoft Learn

      • Hayden_RP's avatar
        Hayden_RP
        New Member
        7 months ago

        I checked in with the PC for the same path and I found the TSNames.ora. I called admin to get acces to moving it because apparently it wasn't in the right spot, and it doesn't do anything when I try and load it in SQL Developer.

         

         

         

    • nrichards_au's avatar
      nrichards_au
      Helper I
      7 months ago

      In Oracle SQL Developer the path to the TNSNames.Ora can be found Tools> Preferences > Database > Advanced

      Bottom of the context window will be a path