Forum Discussion

JennyMilf's avatar
JennyMilf
Helper I
3 years ago
Solved

Connect Oracle database - deprecate

Hello, I am trying connect Oracle to Power BI desktop I already installed Oracle Client provider, but I get a error like photo below. If anyone can help me? Thank you!  
Need Help
  • v-yueyunzh-msft's avatar
    v-yueyunzh-msft
    3 years ago

    Hi , JennyMilf 

    First , you need to check the string connect text is right in configuration file "tnsnames.ora".

    It is in directory: E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin

    Then you can try to use the "DLPOracle" text to the "Server" input box to try to:

     

    Secondly , you can try to use this "ip:port/servername" in "Server" input box.

     

    Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

     

    Best Regards,

    Aniya Zhang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

JennyMilf's avatar
JennyMilf
Helper I
3 years ago

Thank you but I don't get it. What should I do now?

v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

Hi , JennyMilf 

First , you need to check the string connect text is right in configuration file "tnsnames.ora".

It is in directory: E:\app\client\adm.user\product\12.2.0\client_1\Network\Admin

Then you can try to use the "DLPOracle" text to the "Server" input box to try to:

 

Secondly , you can try to use this "ip:port/servername" in "Server" input box.

 

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

 

Best Regards,

Aniya Zhang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly