Hello,
I am trying to get data from our linux based DB2 10.5 server. Full version:
uses "64" bits and DB2 code release "SQL10056" with level identifier
"0607010E".
Informational tokens are "DB2 v10.5.0.6", "s150731", "IP23643", and Fix Pack
"6".
The data loads for a while then it throws an unexpected error with the following details:
Feedback Type:
Frown (Error)
Timestamp:
2017-09-01T06:47:34.3915191Z
Local Time:
2017-09-01T08:47:34.3915191+02:00
Product Version:
2.49.4831.521 (PBIDesktop) (x64)
Release:
August 2017
IE Version:
11.0.9600.17031
OS Version:
Microsoft Windows NT 6.3.9600.0 (x64 en-US)
CLR Version:
4.6.2. or later [Release Number = 394806]
Workbook Package Info:
1* - en-US, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
475 MB
Private Memory:
312 MB
Peak Virtual Memory:
1.7 GB
Error Message:
Couldn't load the model schema.
User ID:
24a5f5db-e5b3-4999-a5ca-317a66cb88b1
Session ID:
9fa5f65e-5f28-463d-a0b4-43f9b9832a57
Telemetry Enabled:
True
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1915329033.zip
Performance Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
Disabled 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:
Fri Sep 01 2017 08:47:08 GMT+0200 (Central Europe Daylight Time)
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared #"ITMUSER LP_K59AVAIL" = let
Source = DB2.Database("172.25.50.4:50000", "warehous", [Implementation="Microsoft", CreateNavigationProperties=false]),
ITMUSER_LP_K59AVAIL = Source{[Schema="ITMUSER",Item="LP_K59AVAIL"]}[Data]
in
ITMUSER_LP_K59AVAIL;
shared #"ITMUSER Application_Server_Status_MV" = let
Source = DB2.Database("172.25.50.4:50000", "warehous", [Implementation="Microsoft"]),
ITMUSER_Application_Server_Status_MV = Source{[Schema="ITMUSER",Item="Application_Server_Status_MV"]}[Data]
in
ITMUSER_Application_Server_Status_MV;
Doesn't matter which driver I chose .NET or DB2 the issue is the same. Any ideas?
3 Comments
- v-haibl-msft
Microsoft Employee
Are you able to connect to your DB2 server using Excel on the same machine where Power BI Desktop is installed?
Best Regards,
Herbert - Vicky_Song
Impactful Individual
Status changed:NewtoNeeds Info - zoveressRegular Visitor
I do not have excel installed on this machine, it is a dedicated powerbi vm ( actually 2 of them ).