ODBC Gateway Connection Error

Hi Syndicate_Admin 

The issue occurs when setting up a gateway in Power BI Service to connect to an Oracle database via ODBC. The error indicates that the TNS name cannot be resolved (ORA-12154).

Solution:
To resolve this, ensure the gateway type is correctly configured, verify the tnsnames.ora and credentials setup, and align the configurations across Power BI Desktop, the gateway, and Power BI Service. Follow these steps:

1. Set the Correct Gateway Type
Install the Standard Mode Gateway, not the Personal Mode Gateway.
Standard Mode is required for shared connections and to allow Power BI Service to access the gateway.
2. Verify Configuration in Desktop and Service
In Power BI Desktop:

Confirm the ODBC connection uses valid Oracle credentials (username/password).
Refresh the dataset to ensure the connection works correctly locally.
In Power BI Service:

Go to the dataset settings (Settings > Datasets).
Under Gateway Connection, select the configured gateway.
Enter the credentials in Data Source Credentials (Oracle username/password).
Use the Test Connection button to validate the configuration.
3. Check tnsnames.ora and Environment Variables
Ensure the tnsnames.ora file is correctly configured and error-free.
Verify the TNS_ADMIN environment variable points to the folder containing the tnsnames.ora file.
Restart the machine after setting TNS_ADMIN.
4. Test the Connection
Use the tnsping command to test connectivity to the Oracle database:
bash
Copy code
tnsping <TNS_ALIAS>

+
Try follow the linked video guide (3 videos):
https://www.youtube.com/@fishleaf/search?query=oracle

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.