Hello,
I am connecting to IBM DB2 via direct query, but upon fetching the data and building the model, i get the error: "Couldn't load the model schema."
I have tried many other suggestions found throughout the community here, but nothing seems to be working.
Below is the error log. Any help is appreciated.
Feedback Type:
Frown (Error)
Timestamp:
2019-02-12T16:00:38.4213425Z
Local Time:
2019-02-12T10:00:38.4213425-06:00
Session ID:
bf58b801-e30e-4a60-9ac6-14a384b6ea2e
Release:
December 2018
Product Version:
2.65.5313.1381 (18.12) (x64)
Error Message:
Couldn't load the model schema.
OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 461814]
Peak Virtual Memory:
33.9 GB
Private Memory:
400 MB
Peak Working Set:
536 MB
IE Version:
11.904.16299.0
User ID:
22c35ed5-e98a-48e9-b097-5564a029394f
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\XXXXXX\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot302477576.zip
Performance Trace Logs:
C:\Users\XXXXXX\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared TABLE1 = let
Source = DB2.Database("server:50000", "database", [HierarchicalNavigation=true, Implementation="IBM"]),
SCHEMA = Source{[Schema="SCHEMA"]}[Data],
TABLE1 = SCHEMA{[Name="TABLE1"]}[Data]
in
TABLE1;
shared TABLE2 = let
Source = DB2.Database("server:50000", "database", [HierarchicalNavigation=true, Implementation="IBM"]),
SCHEMA = Source{[Schema="SCHEMA"]}[Data],
TABLE2 = SCHEMA{[Name="TABLE2"]}[Data]
in
TABLE2;
shared TABLE3 = let
Source = DB2.Database("server:50000", "database", [HierarchicalNavigation=true, Implementation="IBM"]),
SCHEMA = Source{[Schema="SCHEMA"]}[Data],
TABLE3 = SCHEMA{[Name="TABLE3"]}[Data]
in
TABLE3;
Thanks,
David
