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.  

nrichards_au's avatar
nrichards_au
Helper I
7 months ago

So Oracle SQL Developer connects to your Oracle Database. This is typically done using an ODBC connection. In PowerBI use the get data option and choose Other then try ODBC and choose the connection to your Oracle SQL server. 

 

If it's not that or the server isn't obvious have a chat to your DBA or IT team about it as they'll know the details of your setup