Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Unable to connect to Oracle database

Hi Folks,

 

I am facing the problem in getting connected to Oracle Database, I am able to get the data but failing to create a model out of it. the error pop up goes something like this

 

Any help will be appreaciated!

 

Regards,

Anjali

Need Help

3 Replies

  • Kishore_KVN's avatar
    Kishore_KVN
    Solution Sage
    3 years ago

    Hello Anonymous , 

    Please see if Oracle Client 12 is installed in your system or not. Once it is installed, Place the entire folder with TSN files in the C drive. Then it will connect. If it doesnt connect then install Oracle ODBC 64/36 drivers as per your system configuration. This will helps to connect. 

     

    If this post helps, then please consider accepting it as the solution to help other members find it more quickly. Thank You!!

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hi Kishore_KVN 

      I have installed Oracle client already along with TNSORA file in C drive, still aint working.

      • Kishore_KVN's avatar
        Kishore_KVN
        Solution Sage
        3 years ago

        Then install Oracle ODBC drivers and while providing the server in Power BI under connecting to Oracle, then you have to use servername\PortName