Forum Discussion
Difficulties connecting Oracle SQL Developer to Power BI
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.
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
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.
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.