Forum Discussion
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" ...
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.
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.
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