Forum Discussion
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;
- Anonymous8 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
- AnonymousNot 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_HansenRegular 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