Data not loading when using a direct connection -- "Can't display the visual" in Desktop.

[asahelduncan]

For the past week or so I've been receving OLE DB or ODBC errors when trying to build a report in Desktop.  I'm using a dataset in direct query mode and combining with spreadsheet data to build a targets and actuals report.  Although the visuals appear in web, the data showing in the tables is not complete across the various rows and columns.  

Feedback Type:
Frown (Error)

Timestamp:
2022-08-09T14:06:38.8053238Z

Local Time:
2022-08-09T10:06:38.8053238-04:00

Session ID:
0b4842cb-c817-4119-afef-457380515988

Release:
July 2022

Product Version:
2.107.841.0 (22.07) (x64)

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 en-US)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
54.5 GB

Private Memory:
799 MB

Peak Working Set:
785 MB

IE Version:
11.789.19041.0

User ID:
5aafa677-2c5f-4ebf-ba67-d6f7bd1e5810

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

Telemetry Enabled:
True

Model Default Mode:
Composite

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_sparklines

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_enhancedTooltips
PQ_WebView2Connector
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[TheShy]

Hi @asahelduncan ,

The existing limitations of DirectQuery still apply when you use composite models. Many of these limitations are now per table, depending upon the storage mode of the table. For example, a calculated column on an import table can refer to other tables, but a calculated column on a DirectQuery table can still refer only to columns on the same table. Other limitations apply to the model as a whole, if any of the tables within the model are DirectQuery. For example, the QuickInsights feature isn't available on a model if any of the tables within it has a storage mode of DirectQuery.

Best Regards，

Shy

[v-xiaoyan-msft]

Kindly see the comments below.