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. If you contact support, please provide these details
  • Activity IDcdb9c18c-7de9-44f1-a047-6919d990f6e0
  • Request IDc66cc514-3ade-2498-4b1b-04862fb8c818
  • Correlation IDf1d08a2c-31bd-cd6b-15b4-aaa5d292872c
  • TimeFri Feb 28 2020 11:17:05 GMT-0500 (Eastern Standard Time)
  • Service version13.0.12439.205
  • Client version2002.3.018

I am getting the above error when I am publishing the report that is developed using Direct Query Option. I am able to publish the report with the import option. But I need to use Direct Query option.

 

I have connected to the on-premises-data gateway successfully, I have the latest version of the Oracle database and Power BI desktop. I am not sure why Direct Query is not working after publishing my report to service. Please help me with this.

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!

5 Replies

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

    Hi Anonymous ，

     

    Have you configured the data source？Here is the reference.

     

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

       

      Hi Kelly,

       

      Yes, Please find the above screenshot for your reference. It is working for the Import option but not for Direct Query. I am not sure why. Please help me with this.

      • v-kelly-msft's avatar
        v-kelly-msft
        Community 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!