Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Could not load data to model

When updated to the latest PBI Desktop version (April 2018) I get the following error message after trying to load the data from MSSQL server.

Could not load data to model.

Feedback Type:
Frown (Error)

Timestamp:
2018-04-09T11:59:18.7665698Z

Local Time:
2018-04-09T13:59:18.7665698+02:00

Session ID:
64a74b0e-d61c-458e-9edf-9c7dbf8f75a7

Release:
April 2018

Product Version:
2.57.5068.501 (PBIDesktop) (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 = 461308]

Peak Virtual Memory:
34.1 GB

Private Memory:
354 MB

Peak Working Set:
509 MB

IE Version:
11.309.16299.0

User ID:
d0538029-dcc1-4d56-9ebe-69cc8c7f86fd

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

Telemetry Enabled:
False

Model Default Mode:
DirectQuery

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @Anonymous,

 

Which kind of SQL Server object do you get data from, table, view or stored procedure?

 

Please use SQL Profile to capture which query passed to SQL Server. Also please enable desktop trace, and repeat steps to retrieve data, find is there any detail error message in log files. 

 

Best Regards,
Qiuyun Yu 

Anonymous
Not applicable

The issue somehow sorted itself out ... you can close the ticket.