Forum Discussion

Kim_Hansen's avatar
Kim_Hansen
Regular Visitor
8 years ago
Solved

Couldn't load the schema for the database model - When using Direct Query

Hi,

 

When I connect to an oracle database - I have no issues when using import mode. However, when I try Direct Query, I get an error "Couldn't load the schema for the database model" with the details as below. Hope anyone has a solution to this. Thanks

 

 

Feedback Type:
Frown (Error)

Timestamp:
2018-05-01T08:11:08.1144239Z

Local Time:
2018-05-01T10:11:08.1144239+02:00

Session ID:
df0e38c4-2882-427f-bc56-5e09bd370cdd

Release:
April, 2018

Product Version:
2.57.5068.721 (PBIDesktop) (x64)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 460805]

Peak Virtual Memory:
3.76 GB

Private Memory:
332 MB

Peak Working Set:
438 MB

IE Version:
11.0.9600.18977

User ID:
6e711224-dd8c-4f19-9d31-cf34903c3119

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\statkhn\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1298612709.zip

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

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_variationUIChange

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_qnaExplore
PBI_canvasTooltips

Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;

shared KHN_MONI_PBIP_24_MEANS = let
Source = Oracle.Database("PRODDWH", [HierarchicalNavigation=true]),
ACCESS_ANALYZE = Source{[Schema="ACCESS_ANALYZE"]}[Data],
KHN_MONI_PBIP_24_MEANS1 = ACCESS_ANALYZE{[Name="KHN_MONI_PBIP_24_MEANS"]}[Data]
in
KHN_MONI_PBIP_24_MEANS1;

  • Anonymous's avatar
    Anonymous
    8 years ago

    Kim_Hansen,

    What is the version of your Oracle server? It requires Oracle version 12 or later when using DirectQuery mode in Power BI Desktop.



    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Kim_Hansen,

    What is the version of your Oracle server? It requires Oracle version 12 or later when using DirectQuery mode in Power BI Desktop.



    Regards,
    Lydia

    • Kim_Hansen's avatar
      Kim_Hansen
      Regular Visitor

      Hi Lydia and thanks.

       

      Yes that solved my issue partly. It now works locally, but when I publish the reports I get an error in the the cloud