cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
totoalbin
Helper I
Helper I

Unexpected Error: Can't Load Model Schema

Hello,

 

I would like to ask for a solution regarding this problem where everytime I open PowerBI it say's can't load model schema.  On top of that.  Any pbix file I open seems to be this way.

 

Here is a screenshot of the problem.

 

Screen Shot 2017-10-13 at 9.21.00 AM.png

 

I tried using just an excel data and still the problem is there.

 

Here is the error it generated:

 

 

Feedback Type:
Frown (Error)

Timestamp:
2017-10-13T01:19:45.0787000Z

Local Time:
2017-10-13T09:19:45.0787000+08:00

Session ID:
0b533511-d7b4-49d3-9d27-2d54cf41e497

Release:
October, 2017

Product Version:
2.51.4885.701 (PBIDesktop) (x86)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x86 en-US)

CLR Version:
4.5 or later [Release Number = 378389]

Peak Virtual Memory:
1.05 GB

Private Memory:
256 MB

Peak Working Set:
317 MB

IE Version:
9.0.8112.16421

User ID:
a986248e-9732-42df-923a-47262e25cefb

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\nuser\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot887002608.zip

Performance Trace Logs:
C:\Users\nuser\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_SpanishLinguisticsEnabled
PBI_reportBookmarks

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 Oct 13 2017 09:19:06 GMT+0800 (China Standard Time)

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

Thank you very much for the help.

 

1 ACCEPTED SOLUTION

Thank you very much for the reply Simon.  Actually it got fixed when I reinstalled my OS, then installed I think Internet Explorer 11 for Windows 7, then dot net framework 4.5 and then installed PowerBI.  

 

 

View solution in original post

9 REPLIES 9
leedstark
New Member

I've had the same issue:

 

Feedback Type:
Frown (Error)

Timestamp:
2018-04-22T11:03:23.5058488Z

Local Time:
2018-04-22T12:03:23.5058488+01:00

Session ID:
1fbc34f4-c060-4b11-a2e4-5f747fd80d91

Release:
March 2018

Product Version:
2.56.5023.1043 (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:
385 MB

Peak Working Set:
504 MB

IE Version:
11.371.16299.0

User ID:
43916977-0b9b-44ab-b2d9-8afe973f7c64

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

Telemetry Enabled:
False

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\Walid\AppData\Local\Microsoft\Power BI Desktop SSRS\FrownSnapShot1807271150.zip

Performance Trace Logs:
C:\Users\Walid\AppData\Local\Microsoft\Power BI Desktop SSRS\PerformanceTraces.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_AdobeAnalytics
PBI_qnaExplore
PBI_variationUIChange
PBI_customVisualsGallery
PBI_canvasTooltips

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
125%

Supported Services:
Power BI Report Server, Power BI

Formulas:


section Section1;

shared TABLE_OT = let
Source = Oracle.Database("10.16.1.11/XE:1521", [HierarchicalNavigation=true]),
AMINE = Source{[Schema="AMINE"]}[Data],
TABLE_OT1 = AMINE{[Name="TABLE_OT"]}[Data]
in
TABLE_OT1;

shared #"AMINE TABLE_OT" = let
Source = Oracle.Database("10.16.1.11/XE:1521", [CreateNavigationProperties=false]),
AMINE_TABLE_OT = Source{[Schema="AMINE",Item="TABLE_OT"]}[Data]
in
AMINE_TABLE_OT;

shared #"AMINE TABLE_OT (2)" = let
Source = Oracle.Database("10.16.1.11/XE:1521", [CreateNavigationProperties=false]),
AMINE_TABLE_OT = Source{[Schema="AMINE",Item="TABLE_OT"]}[Data]
in
AMINE_TABLE_OT;

Molly_Malone
New Member

Come on Microsoft you have known about this issue for a long time now, is anyone working on a fix?

Molly_Malone
New Member

This is an update to my last post, i just tried creating a simple table in BI, a few columns and 15 odd rows of data, when I go to load the data I get the same error, see grab. BI Error.png

Molly_Malone
New Member

I keep getting the same Unexpected Error: Can't load model schema, I have tried many different files types, and turend off my VPN, do anyone know of a solution?

 

ScorpionKing
Frequent Visitor

Same here. Will get the error if connected to VPN. Need to disconnect so the error will disappear problem is I can't connect to my source data if disconnected to VPN.

 

Thanks.

totoalbin
Helper I
Helper I

Hello,

 

I would like to ask for a solution regarding this problem where everytime I open PowerBI it say's can't load model schema.  On top of that.  Any pbix file I open seems to be this way.

 

Here is a screenshot of the problem.

 

Screen Shot 2017-10-14 at 9.47.42 AM.png

 

I tried using just an excel data and still the problem is there.

 

Here is the error it generated:

 

Feedback Type:
Frown (Error)

Timestamp:
2017-10-13T01:19:45.0787000Z

Local Time:
2017-10-13T09:19:45.0787000+08:00

Session ID:
0b533511-d7b4-49d3-9d27-2d54cf41e497

Release:
October, 2017

Product Version:
2.51.4885.701 (PBIDesktop) (x86)

Error Message:
Couldn't load the model schema.

OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x86 en-US)

CLR Version:
4.5 or later [Release Number = 378389]

Peak Virtual Memory:
1.05 GB

Private Memory:
256 MB

Peak Working Set:
317 MB

IE Version:
9.0.8112.16421

User ID:
a986248e-9732-42df-923a-47262e25cefb

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\nuser\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot887002608.zip

Performance Trace Logs:
C:\Users\nuser\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_SpanishLinguisticsEnabled
PBI_reportBookmarks

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 Oct 13 2017 09:19:06 GMT+0800 (China Standard Time)

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

Thank you very much for reading this.

v-sihou-msft
Microsoft
Microsoft

@totoalbin

 

Did you enable VPN on your local machine?

 

We have seen similar the issue when enabling VPN. This issue has been reported internally, it's still fixing.

 

Regards,

Same issue here when using VPN. Currently running 2.51.4885.701 64-bit (October 2017), updated to 2.52.4921.581 64-bit (November 2017) and still having the same issue.

 

Do we have an ETA when this issue will be resolved?

Thank you very much for the reply Simon.  Actually it got fixed when I reinstalled my OS, then installed I think Internet Explorer 11 for Windows 7, then dot net framework 4.5 and then installed PowerBI.  

 

 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors