Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I installed Oracle client, yet I get error when I attempt to get Oracle data into PowerBI
Please assist
Error Details: "Oracle: ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA"
Here is tnsnames.ora
DLPOracle = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = SERVER_NAME)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = service_name) ) )
It is in directory: E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin
PATH contains
E:\app\client\adm.user\product\12.2.0\client_1 E:\app\client\adm.user\product\12.2.0\client_1\bin
Hi @ArtieLadie,
Perhaps you can have a look at the article below:
You may encounter serveral errors from Oracle when the naming syntax is either incorrect or not configured properly.
These errors could occur if either the Oracle client is not installed, or if it is not configured properly. If it is installed, you will want to verify the tnsnames.ora file is properly configured and you are using the proper net_service_name. You will also need to make sure that the net_service_name is the same between the machine using Power BI Desktop and the machine that is running the gateway. For more information, see Installing the Oracle Client.
In addition, please have a reference of this similar thread which has been solved.
Best Regards,
Cherry
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.