cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pablo20
Frequent Visitor

PowerBi desktop doesn't connect oracle 11g or 12g when use:server_example:1525/service_name_example.

When i use:

get data from-->oracle, i configure the server with name_serve:port/service_name but this configuration doesn't work.

I recibe:"ORA-12154: TNS:could not resolve the connect identifier specified.". In my tnsnames.ora i have configurated
example.world =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server_example)(PORT = 1525))
(CONNECT_DATA =
(SERVICE_NAME = service_name_example
)
)

i try this: server_example:1525/service_name_example. Does not work.
but if i use: example.word it's OK, work.

but i requiere server_example:1525/service_name_example because in my organization this require.

can you help me?

1 ACCEPTED SOLUTION
pablo20
Frequent Visitor

Hello !, I was able to configure it today.
In my tnsnames.ora just add:
server_example: 1525 / server_example =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = server_example)
(PORT = 1525)
)
(CONNECT_DATA =
(SERVICE_NAME = service_name_example)
)
)

The problem was in the configuration made by the gateway administrator and he was inflexible in changing it.

Thanks for the help.

Resume:
Configure the database configuration in tnsnames.ora using the connection string in the CONNECTION DESCRIPTOR:
"server_example: 1525 / server_example"

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

"because in my organization this require"

 

Does that mean your organization does not allow the use of TNSNAMES.ORA and forces you to use tns-less connections?

TNS-less connection string - OraOLEDB.Oracle - ConnectionStrings.com

 

Worst case you could switch to the ODBC driver (and lose some performance)

pablo20
Frequent Visitor

Hello !, I was able to configure it today.
In my tnsnames.ora just add:
server_example: 1525 / server_example =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = server_example)
(PORT = 1525)
)
(CONNECT_DATA =
(SERVICE_NAME = service_name_example)
)
)

The problem was in the configuration made by the gateway administrator and he was inflexible in changing it.

Thanks for the help.

Resume:
Configure the database configuration in tnsnames.ora using the connection string in the CONNECTION DESCRIPTOR:
"server_example: 1525 / server_example"

 

View solution in original post

"inflexible"  is a nice way to describe this.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!