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

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

Hi , JennyMilf 

As searched , you can try to :
1.LOCATE AND COPY THE ORAONS.dll FILE IN E:Oracle11gclientproduct12.2.0client_1 Install the power BI connection oracle plugin:

2.Paste the oraons.dll file into the E:Oracle11gclientproduct12.2.0client_1bin directory

 

 

You also can check if the solutions in the following similar threads help.

Solved: PowerBI desktop 64Bit oracle connection error Obj... - Microsoft Power BI Community

Solved: Re: PowerBI desktop 64Bit oracle connection error ... - Microsoft Power BI Community

powerbi - how to solve Object reference not set to an instance of an object in Power BI and the source file is an Excel Macro file - Stack Overflow

 

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

A new error after doing the reference you shared 😞 

 

 

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

    Hi , JennyMilf 

    This error usually occurs because the listener did not find the corresponding service_name, you can try to change your connection string, such as ip/database instance name and others different combinations to try to test it may connect (sorry for i have no environment to test it).

    If this can not solve this problem , you can refer to :

    For more information, you can refer to :
    .net - Oracle error: TNS: Listener was not given the SERVICE_NAME in CONNECT_DATA 1 - Stack Overflow

     

    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