Direct query cannot load model schema

[dniedrauer]

So this has been discussed here, but none of the previous answers apply here. I get the following error whenever I try to load a direct query from an Oracle database into Power BI Desktop. 

Here's all the info from the error: 

Feedback Type:

Frown (Error)

Timestamp:

2017-10-20T16:17:43.4695262Z

Local Time:

2017-10-20T11:17:43.4695262-05:00

Session ID:

b548a9fd-f43c-499c-bb73-46abafe11b88

Release:

October 2017

Product Version:

2.51.4885.701 (PBIDesktop) (x64)

Error Message:

Couldn't load the model schema.

OS Version:

Microsoft Windows NT 10.0.14393.0 (x64 en-US)

CLR Version:

4.6.2 or later [Release Number = 394802]

Peak Virtual Memory:

33.8 GB

Private Memory:

324 MB

Peak Working Set:

477 MB

IE Version:

11.1715.14393.0

User ID:

8cc458f8-44e7-49be-b3b2-4057222732bc

Workbook Package Info:

1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:

True

Model Default Mode:

DirectQuery

Snapshot Trace Logs:

C:\Users\david.niedrauer\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1136000085.zip

Performance Trace Logs:

C:\Users\david.niedrauer\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_numericSlicerEnabled

PBI_daxTemplatesEnabled

CustomConnectors

PBI_reportBookmarks

Disabled Preview Features:

PBI_EnableReportTheme

PBI_SpanishLinguisticsEnabled

Enabled DirectQuery Options:

PBI_DirectQuery_Unrestricted

Cloud:

GlobalCloud

Couldn't load the schema for the database model:

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

1. Credentials: credentials for the DB are correct, and in any case, loading the rows from the database works, so I don't see this as the problem. Only direct query presents a problem here. 

2. Clear cache: tried

3. Upgrade to October release of PBI Desktop: tried. 

4. Connection to the DB: like I said, loading the rows into PBI the normal way works, so I don't see how this is the problem either.  It's only a problem with Direct query. 

I'm out of ideas. Can someone please help? 

[Anonymous]

Same in my case. Latest Oracle XE database. 

Import works, DirectQuery does not work.

The report was tested using the desktop version.

Here both works perfectly.

When using a PowerApp to access the data it also works when using the gateway.

Only the published report has a problem when calling it within the browser.

Using the same scenario with a Microsoft SQL server also both methods were successful.

[Kuro]

You can try to install the orcale database client in Runtime type not the instantclient, than the problem should be fixed.

[v-yulgu-msft]

Hi @dniedrauer,

If you append port number after your server address, please remove it and try again.

Regards,
Yuliana Gu

[GuySev]

Hi @v-yulgu-msft! That was it for me, thanx!

[dniedrauer]

This is the format I have for the server servername:1521/datasourcename 

it works fine for data load. Should the format be different for direct query and if so what? 

[v-yulgu-msft · Accepted solution]

Hi @dniedrauer,

What is your Oracle database version? To support Direct Query, Oracle Database should be version 12 and above.

By the way, do mask sensitive data before uploading your persoanl information.

Regards,
Yuliana Gu

[Anonymous]

My Oracle Database version is 18.0.0.0.0. I am having the same issue with Direct Query.

[dniedrauer]

This is a very useful answer. 

Because no, it's 11-something, and this is what I was afraid of...