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