Forum Discussion

totoalbin's avatar
totoalbin
Helper I
8 years ago
Solved

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.

 

 

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.

 

  • totoalbin's avatar
    totoalbin
    8 years ago

    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.  

     

     

9 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Microsoft Employee

    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,

    • totoalbin's avatar
      totoalbin
      Helper I

      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.  

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable

      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?

  • 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.

     

     

    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.

  • ScorpionKing's avatar
    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.

  • 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?

     

  • 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.

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

  • 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;