topic Re: Gateway connection error in Pipelin in Pipelines

Gateway connection error in Pipelin

FredrikJ — Mon, 16 Jun 2025 15:29:21 GMT

Hi!

I am using an Gateway connection to Oracle in a Pipelin in Fabric and gets this error message: Test connection operation failed. Failed to open the Oracle database connection. ORA-12154: TNS:could not resolve the connect identifier specified.

The same gateway connection is used to get data import to Semantic models in fabric and is working fine in this case.

We are running the lastest version of the Gateway.

Regards

Fredrik

Re: Gateway connection error in Pipelin

mabdollahi — Thu, 19 Jun 2025 03:24:48 GMT

Hi FredrikJ

The error you're seeing — ORA-12154: TNS: could not resolve the connect identifier specified — usually means the connection name can’t be found or isn’t recognized. This often comes down to something simple, like a typo in the connection string or a missing entry in the tnsnames.ora file.

Since the same gateway connection works fine for importing data into Semantic Models, it’s worth double-checking that the pipeline is using exactly the same connection settings. Sometimes even a small difference, like an extra space or different format, can cause this error.

Also, make sure the Oracle client and tnsnames.ora file on the gateway machine are correctly set up and can resolve the connection name used in the pipeline.
Regards,
Mehrdad Abdollahi

Re: Gateway connection error in Pipelin

v-sdhruv — Thu, 19 Jun 2025 07:14:56 GMT

Hi FredrikJ ,

In addition, you can also try to check the gateway connection by entering the full string under Server:
You can also check the following-

Reference-

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-oracle-database#connect-to-an-oracle-database-with-the-on-premises-data-gateway

If it still doesnt work, check out this solved similar query in the forum
Connect to Oracle Error - ORA-12154: TNS:could not resolve the connect identifier specified

Hope this helps!

If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

Re: Gateway connection error in Pipelin

v-sdhruv — Mon, 23 Jun 2025 12:20:14 GMT

Hi FredrikJ ,
Just wanted to check if you had the opportunity to review the suggestion provided?
If the response has addressed your query, please accept it as a solution so other members can easily find it.
Thank You

Re: Gateway connection error in Pipelin

FredrikJ — Mon, 23 Jun 2025 12:48:38 GMT

Hi!

I have tried the gateway connection by entering the full string under Server and it works. But I am still confused by why it works fine with the TNS name when I use it for getting data to a Semantic Model but not when used in Copy data in a Pipeline.