cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joaosantos Regular Visitor
Regular Visitor

Couldn't load the schema for the database model

Hello. If I try to direct query to a Oracle DB, I always get this error. Does anyone have any idea how to fix?

 

Here's the details:

 

Feedback Type:
Frown (Error)

Timestamp:
2018-07-22T10:13:25.2673698Z

Local Time:
2018-07-22T11:13:25.2673698+01:00

Session ID:
e4ba6158-e726-4616-a44d-c4abfcdaac41

Release:
February 2018

Product Version:
2.55.5010.641 (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.7 or later [Release Number = 460805]

Peak Virtual Memory:
34.1 GB

Private Memory:
439 MB

Peak Working Set:
552 MB

IE Version:
11.2189.14393.0

User ID:
bab14742-a5d4-4cff-8247-99227d97fbf6

Workbook Package Info:
1* - pt-PT, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\jpsantos\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1218832165.zip

Performance Trace Logs:
C:\Users\jpsantos\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_reportBookmarks
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_HanaV2

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.

Activity ID:
null

Time:
Sun Jul 22 2018 11:10:31 GMT+0100 (GMT Daylight Time)

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared Query2 = let
    Source = Oracle.Database("---"])
in
    Source;
1 REPLY 1
Highlighted
zoloturu
Advisor

Re: Couldn't load the schema for the database model

Hi @joaosantos,

 

Please answer on below questions:

1. Are you able to connect to Oracle DB via any database management tool like Database browser, SQL Developer etc.?

2. How much memory (RAM) are consuming by your report during refresh. Check it via Windows Resource Monitor. See details - https://www.digitalcitizen.life/how-use-resource-monitor-windows-7

3. Which version of Oracle DB you have? There are 12 and above which are under support for Direct Query - https://docs.microsoft.com/en-us/power-bi/desktop-directquery-data-sources

4. Provide screenshots on how you receive an error.

 

Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!