Power BI Oracle connetion - Details: “Oracle: ”

Question

When I am trying to acess Oracle DB and Power Bi its showing the following message

Details: "Oracle." ". Connection to DB is working for me when tested with SQL Plus or other tools. At the same time, colleague of mine can access same DB from Power BI, with same Oracle client

How can I resolve it? 

Answer 1

• Install the version of the Oracle Client in your PC 

• Open Power BI --> Home --> Get Data --> Oracle Database

In the SERVER you must put the TNS connection STRING in the format:

MYSID=(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = mydnshostname)(PORT = myport))(CONNECT_DATA = (SERVICE_NAME = MYSID)))

Want to learn more about Power Bi, Refer & learn Power bi

Learn Power BI Course from this video : 

 

Intellipaat gives its learners an industrial training on Power BI Course. Enroll now to get a professional certificate!