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 you please help me .

 

Thanks,

Bhakti

Custom Visuals
Dashboards

3 Replies

  • 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?