Power bi Connect with Oracle 12C

[Anonymous]

Hi 

I need to connect power bi with Oracle 12C which tool install for this conncetion and why they need ?

I have  oracle sql Develpoer already install in my system and connect with power bi .

can you please help me .

Thanks,

Bhakti

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

For Power BI desktop to connect to Oracle, we need to install Oracle client on the machine which has Power BI desktop running, see: https://docs.microsoft.com/en-us/power-bi/desktop-connect-oracle-database

For Power BI service, the Oracle needs to be instlled on the same mahine as on-premise data gateway runs on, see: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-manage-oracle

Best Regards,
Qiuyun Yu 

[pablo20]

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?

[Anonymous]

Hi 

  Thank you for your help to resolve this issue.

Thanks ,

Bhakti