Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Power bi Connect with Oracle 12C

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 ...
Custom Visuals
Dashboards
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
8 years ago

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 

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Hi 

      Thank you for your help to resolve this issue.

     

    Thanks ,

    Bhakti

  • pablo20's avatar
    pablo20
    Frequent Visitor
    5 years ago

    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?