Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Direct Query-Couldn't load the model schema associated with this report. Make sure you have a connec

Error: Cannot load model Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.  Please try again later or contact support. ...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    The use of DirectQuery with Oracle in Power BI requires to use the ODP.NET driver from Oracle.

    1. Get the ODAC driver from this link: https://www.oracle.com/database/technologies/odac-downloads.html
    2. Take the version with the setup included (not the XCopy)
    3. The one below is the latest known starting 2020:
    4. Launch the setup and after few screens ensure the ODP.NET driver is selected:

    5 At the next screen ensure the ODP.NET driver is setup machine wide (this is very important):

    6.Complete the setup, no restart of Windows is required, but a restart of the PBI Desktop tool or of the OPDG service is needed.

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
v-kelly-msft's avatar
v-kelly-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi  Anonymous ,

 

Direct query should also show such screenshot,did you fail in configuring the data source in direct query mode,or is there not existing an option for you to choose in direct query mode?Can you show me such screenshot in direct query mode?

If you cant configure the data source,better choose a window authentication.

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!
Anonymous's avatar
Anonymous
Not applicable
6 years ago

The above screenshot I shared  is for Direct query mode only. Even after choosing the datasource I am getting "Couldn't load the model schema associated with this report" error.

  • v-kelly-msft's avatar
    v-kelly-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ，

     

    The use of DirectQuery with Oracle in Power BI requires to use the ODP.NET driver from Oracle.

    1. Get the ODAC driver from this link: https://www.oracle.com/database/technologies/odac-downloads.html
    2. Take the version with the setup included (not the XCopy)
    3. The one below is the latest known starting 2020:
    4. Launch the setup and after few screens ensure the ODP.NET driver is selected:

    5 At the next screen ensure the ODP.NET driver is setup machine wide (this is very important):

    6.Complete the setup, no restart of Windows is required, but a restart of the PBI Desktop tool or of the OPDG service is needed.

     
    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!