Forum Discussion

apsaunders5's avatar
apsaunders5
Regular Visitor
8 years ago

Oracle DB connection

  I have read through the various threads on here to identify recommended steps, to no avail. I am trying to connect Power BI desktop to an oracle DB for reporting.    Power BI version: 2.55.5010....
Anonymous's avatar
Anonymous
Not applicable
8 years ago

apsaunders5,

Are you able to connect to Oracle from SQLPLUS or SQL developer? Make sure  that SQL developer or SQLPLUS is installed in the same machine as Power BI Desktop.

In addition, what is the format of connection string do you use in Power BI Desktop?Have you tried to use host: port/servicename? Also please check if your firewall blocks the port.

There is also a similar blog for your reference.
https://oracletempspace.wordpress.com/2011/05/15/error-ora-12504-tnslistener-was-not-given-the-service_name-in-connect_data/


Regards,
Lydia

  • apsaunders5's avatar
    apsaunders5
    Regular Visitor
    8 years ago

    Lydia - Thanks for the response. Yes I am able to connect with SQL developer. Firewall is not blocking the port. When attempting to "GetData" from Oracle DB, I provide the server FQDN as the only input. Is there another option for an Oracle connection string in PowerBI? I noticed the input was different for "GetData" against SQL Server. I will reference the blog post in the meantime. 

     

    Andrew