Couldn't load model schema

[gagoush]

Hi,

I am having an issue with DirectQuery on IBM DB2.

I am loading one table without any issue but I have just afterwards this message : Couldn't load model schema

Here is the log :

***********************************
Feedback Type:
Frown (Error)

Timestamp:
2018-08-22T07:56:41.8502021Z

Local Time:
2018-08-22T09:56:41.8502021+02:00

Session ID:
8bdcec3a-47c5-440f-a84b-669be6a879a5

Release:
August 2018

Product Version:
2.61.5192.601 (18.08) (x64)

Error Message:
Impossible de charger le schéma de modèle.

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 fr-FR)

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

Peak Virtual Memory:
34.3 GB

Private Memory:
589 MB

Peak Working Set:
873 MB

IE Version:
11.309.16299.0

User ID:
ec7af851-81fa-47ad-bd4c-d9ff2f67cb65

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\FrownSnapShot1921936986.zip

Performance Trace Logs:
C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
PBI_compositeModels
PBI_DB2DQ

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_variationUIChange
PBI_canvasTooltips
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:


section Section1;

shared Requête1 = let
    Source = DB2.Database("as400chaprod.axereal.dom:446", "S6558D3B", [Implementation="Microsoft", Query="SELECT NTSTIE,#(lf)    NTSCIV,#(lf)    NTSNOM,#(lf)    NTSSER,#(lf)    NTSAD1,#(lf)    NTSAD2,#(lf)    NTSCPO,#(lf)    NTSVIL,#(lf)    NTSCID,#(lf)    NTSNOD,#(lf)    NTSSED,#(lf)    NTSA1D,#(lf)    NTSA2D,#(lf)    NTSCPD,#(lf)    NTSVID,#(lf)    NTSLIR,#(lf)    NTSTEL,#(lf)    NTSPOT,#(lf)    NTSTEA,#(lf)    NTSFAX,#(lf)    NTSTLX,#(lf)    NTSTDO,#(lf)    NTSFTI,#(lf)    NTSADI,#(lf)    NTSDEV,#(lf)    NTSPAY,#(lf)    NTSCOI,#(lf)    NTSSIR,#(lf)    NTSSTJ,#(lf)    NTSTVI,#(lf)    NTSDEN,#(lf)    NTSDSO,#(lf)    NTSMOT,#(lf)    NTSANC,#(lf)    NTSANF,#(lf)    NTSZLI,#(lf)    NTSC01,#(lf)    NTSC02,#(lf)    NTSC03,#(lf)    NTSS01,#(lf)    NTSS02,#(lf)    NTSS03,#(lf)    NTSS04,#(lf)    NTSS05,#(lf)    NTSS06,#(lf)    NTSS07,#(lf)    NTSS08,#(lf)    NTSS09,#(lf)    NTSS10,#(lf)    NTSS11,#(lf)    NTSS12,#(lf)    NTSS13,#(lf)    NTSS14,#(lf)    NTSS15,#(lf)    NTSS16,#(lf)    NTSS17,#(lf)    NTSS18,#(lf)    NTSS19,#(lf)    NTSS20,#(lf)    NTSS21,#(lf)    NTSS22,#(lf)    NTSS23,#(lf)    NTSS24,#(lf)    NTSS25,#(lf)    NTSDTC,#(lf)    NTSDTM,#(lf)    NTSDTS,#(lf)    NTSUSC,#(lf)    NTSUSM#(lf)FROM S6558D3B.IDAFCGEN.TIERSP", CreateNavigationProperties=false])
in
    Source;

*************************

Thanks for your help,

Gary

[v-qiuyu-msft]

Hi @gagoush,

I have reported this internally: CRI 81123748. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @gagoush,

I got information internally below:

Two things:

1. You're not going to be able to use the canvas due to the issue CRI 78852418. I have coded a fix, but there have been delays in getting it checked in.

2. I see that you put a select statement in the "Query" field. If you do that, you will not be able to use Direct Query mode. Leave it blank, and you can navigate to your table using the UI.

Best Regards,
Qiuyun Yu 

[gagoush]

Thanks a lot for your answers.

I understood point 2 so I got rid of the query. Is this suppose to be normal behaviour? THe workaround is to use views then I suppose?

As for point 1, this is exactly the behaviour I got. Unable to retrieve any data when dragging and drop into the canva.

When do u think the fix will be available?

Thanks,

[v-qiuyu-msft]

Hi @gagoush,

1. Tentative ETA (error occurs when dragging data to canvas) is the November Release.

2. The code is till in review. Plan to release the change is tentatively scheduled for November Release. 

Best Regards,
Qiuyun Yu 

[gagoush]

Thanks for the info.

Best regards,

Gary

[Anonymous]

Hi,

The issue still remains and I have the November release.

Can u help please?

Thks,

*********************************

Feedback Type:
Frown (Error)

Timestamp:
2018-11-16T08:46:45.2754134Z

Local Time:
2018-11-16T09:46:45.2754134+01:00

Session ID:
15358704-b61f-4d22-b2c9-2062dabfa002

Release:
November 2018

Product Version:
2.64.5285.582 (18.11) (x64)

Error Message:
Erreur OLE DB ou ODBC : [Expression.Error] Nous n'avons pas pu plier l'expression sur la source de données. Essayez une expression plus simple..

OS Version:
Microsoft Windows NT 10.0.16299.0 (x64 fr-FR)

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

Peak Virtual Memory:
34.2 GB

Private Memory:
614 MB

Peak Working Set:
803 MB

IE Version:
11.309.16299.0

User ID:
ec7af851-81fa-47ad-bd4c-d9ff2f67cb65

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\FrownSnapShot364891019.zip

Performance Trace Logs:
C:\Users\gary.cochard\Microsoft\Power BI Desktop Store App\PerformanceTraces.zip

Enabled Preview Features:
MIntellisense
PBI_PdfImport
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI

Formulas:

section Section1;

shared AGRICULT = let
    Source = DB2.Database("AS400CHAPROD.AXEREAL.DOM:446", "S6558D3B", [HierarchicalNavigation=true, Implementation="Microsoft"]),
    SDGENERAL = Source{[Schema="SDGENERAL"]}[Data],
    AGRICULT1 = SDGENERAL{[Name="AGRICULT"]}[Data]
in
    AGRICULT1;

[v-qiuyu-msft]

Hi all, 

I have tested with Power BI desktop November version 2.64.5285.741, the issue still here. I already consulted it internally, will keep you update once I get any information. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Any feedback?

or do you know a workaround for connecting to IBM  DB2 real time?

[v-qiuyu-msft]

Hi all, 

Creating the fix is still in progress. Will update here once get new information. 

Best Regards,
Qiuyun Yu