title: PowerBI connecting with Oracle-DB: ORA-12154
body: <p>I am trying to connect <strong>PowerBI</strong> with <strong>Oracle-DB</strong> with no success.</p>
  
  <ul>
  <li>First: when I open <strong>PowerBI</strong> and try to connect the <strong>Oracle Database</strong> on <strong>Get Data</strong> Icon, I get the following error:</li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/h6Dzp.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/h6Dzp.png" alt="enter image description here"></a></p>
  
  <ul>
  <li>Second: I click ok and try to set the connection mannualy:</li>
  </ul>
  
  <p><a href="https://i.stack.imgur.com/0APuR.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/0APuR.png" alt="enter image description here"></a> </p>
  
  <p>But in the end I get the <strong>ORA-12145: TNS:could not resolve the connect identifier specified</strong> error:</p>
  
  <p><a href="https://i.stack.imgur.com/RaSCu.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/RaSCu.png" alt="enter image description here"></a></p>
  
  <p>I don't know what's happening since my Oracle version is the most recent one (<strong>Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production</strong>):</p>
  
  <p><a href="https://i.stack.imgur.com/k5if3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/k5if3.png" alt="enter image description here"></a></p>
  
  <p>Also, my PowerBI Desktop version is <strong>Version: 2.63.3272.40262 64-bit (October 2018)</strong></p>
  
  <p>I've already set up the <strong>tsnames.ora</strong> and <strong>listener.ora</strong> files, but nothing helped.</p>
  
  <p>Do you have an idea how to figure that out?</p>