Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago
Solved

Problem creating connection to Oracle model

Good morning to the whole community I am currently working on a DB that is hosted on an Oracle server. I can connect without problem to the server and see the repository where I have saved the vi...
  • Syndicate_Admin's avatar
    Syndicate_Admin
    4 years ago

    Thank you for your reply. The version of ODAC can not be changed since I am working directly on the server, however I decided to wait for the data load and after a while - about 30 minutes - I could load the view. This looks like a glitch of Power BI's Oracle connection.

v-luwang-msft's avatar
v-luwang-msft
Community Support
4 years ago

Hi Syndicate_Admin ,

Try to  installed an older version of 64-bit ODAC 12c Release 4 (12.1.0.2.4) for Windows x64.

Similar question refer:https://www.oracle.com/database/technologies/odac-downloads.html

Alternatively you can try to create another similar view based on the problem view (delete tables, fields in the view and use rownum to limit the amount of data to try again to locate the problem).

 

Did I answer your question? Mark my post as a solution!


Best Regards

Lucien

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    4 years ago

    Thank you for your reply. The version of ODAC can not be changed since I am working directly on the server, however I decided to wait for the data load and after a while - about 30 minutes - I could load the view. This looks like a glitch of Power BI's Oracle connection.