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

[Anonymous]

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.

[v-kelly-msft]

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]

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]

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]

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 · Accepted solution]

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!