'Couldn't load the model schema' message when connected to company VPN

[mjsmith1568]

When starting 64bit Power BI Desktop on Windows Server 2012, I immediately get the message "Couldn't load the model schema". Subsequently, When I try to load data, say an Excel file, I get the same message and the load fails.

If I disconnect from the company VPN, startup behaves normally, and the load of the Excel data does not fail.

[mjsmith1568]

Hi Herbert, Sorry for the delay. I downloaded and installed the June update. I do not see the error with this version either when I initially open Power BI Desktop, or when I load the Excel file of random numbers. However, when I try to load a visual as you ask, I get a message "Can't display the Visual". Here is the link to all the files, traces, and details. https://1drv.ms/u/s!AqqE2kkIptu4hGKVcfFjd3Iyt-iL

Thanks, Matt

Here are the details from the message...

Feedback Type:
Frown (Error)

Timestamp:
2017-11-01T23:51:38.5698490Z

Local Time:
2017-11-01T16:51:38.5698490-07:00

Product Version:
2.47.4766.421 (PBIDesktop) (x64)

Release:
June 2017

IE Version:
11.0.9600.16438

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

CLR Version:
4.5.2 or later [Release Number = 379893]

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

Peak Working Set:
422 MB

Private Memory:
281 MB

Peak Virtual Memory:
2.06 GB

Error Message:
Couldn't retrieve the data for this visual. Please try again later.

User ID:
95aca962-267e-4bad-8968-3f95f1394ec9

Session ID:
58a0736f-6078-4903-aa2a-a6a3c4187548

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Administrator\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot2057764044.zip

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

Disabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_allowBiDiCrossFilterInDirectQuery
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled
PBI_relativeDateSlicer
CustomConnectors

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted

Cloud:
GlobalCloud

Time:
Wed Nov 01 2017 16:51:35 GMT-0700 (Pacific Daylight Time)

Error Code:
OpenConnectionError

OData Error Message:
Failed to open the MSOLAP connection.

DPI Scale:
100%

Supported Services:
Power BI

Formulas:

section Section1;

shared Sheet1 = let
Source = Excel.Workbook(File.Contents("J:\ASRockServerVol01\Transfer\PLASPROD Database\NinteenColumnNumbers.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Column 1", Int64.Type}, {"Column 2", Int64.Type}, {"Column 3", Int64.Type}, {"Column 4", Int64.Type}, {"Column 5", Int64.Type}, {"Column 6", Int64.Type}, {"Column 7", Int64.Type}, {"Column 8", Int64.Type}, {"Column 9", Int64.Type}, {"Column 10", Int64.Type}, {"Column 11", Int64.Type}, {"Column 12", Int64.Type}, {"Column 13", Int64.Type}, {"Column 14", Int64.Type}, {"Column 15", Int64.Type}, {"Column 16", Int64.Type}, {"Column 17", Int64.Type}, {"Column 18", Int64.Type}, {"Column 19", Int64.Type}})
in
#"Changed Type";

[nairarunv]

Hi Team,

I'm currently experiencing the same issue with PowerBI Desktop running on Windows 10, when running on VPN, when not on VPN there is no issue.

Tried October and November release but getting the error could not load model.

The above error is as soon as I launch, the details are as below

Feedback Type:
Frown (Error)

Timestamp:
2017-11-15T00:49:22.6211151Z

Local Time:
2017-11-15T11:49:22.6211151+11:00

Session ID:
d83c8f48-84c4-4dea-bf14-2df0a3e03613

Release:
November 2017

Product Version:
2.52.4921.581 (PBIDesktop) (x64)

Error Message:
Couldn't load the model schema.

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

CLR Version:
4.6.2 or later [Release Number = 394802]

Peak Virtual Memory:
33.8 GB

Private Memory:
249 MB

Peak Working Set:
357 MB

IE Version:
11.1770.14393.0

User ID:
d5efdd9a-5e22-489e-8b7a-90213b473410

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\Arun_Nair1\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1900776395.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_SpanishLinguisticsEnabled
PBI_daxTemplatesEnabled
CustomConnectors
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:
Wed Nov 15 2017 11:47:38 GMT+1100 (AUS Eastern Daylight Time)

DPI Scale:
150%

Supported Services:
Power BI

Formulas:

section Section1;

[zoveress]

Any progress with this issue? I am trying to access the database through my company's VPN and it keeps failing with this error. I am using the latest version: Version: 2.53.4954.621 64-bit (December 2017)

It would be great if you guys could fix it as I am unable to use the product like this.

[lcallicutt]

I am trying to connect to 7 tables but I keep getting 'Couldn't load the model schema'. Can you please let me know if I need more memory or just work on a server.

Feedback Type:
Frown (Error)

Timestamp:
2018-01-10T13:35:24.0442042Z

Local Time:
2018-01-10T08:35:24.0442042-05:00

Session ID:
15b2e567-a41a-45e0-9e3f-3032c3aa8fcd

Release:
December, 2017

Product Version:
2.53.4954.481 (PBIDesktop) (x86)

Error Message:
Couldn't load the model schema.

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

CLR Version:
4.6.1 or later [Release Number = 394271]

Peak Virtual Memory:
1.65 GB

Private Memory:
629 MB

Peak Working Set:
768 MB

IE Version:
11.0.9600.18893

User ID:
7667eb3d-7acb-435b-b437-9bb10d16b903

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

Telemetry Enabled:
True

Model Default Mode:
DirectQuery

Snapshot Trace Logs:
C:\Users\linette.callicutt\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot875315084.zip

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

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_daxTemplatesEnabled
CustomConnectors

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_reportBookmarks
PBI_AdobeAnalytics
PBI_qnaExplore

Enabled 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:
Wed Jan 10 2018 08:33:33 GMT-0500 (Eastern Standard Time)

DPI Scale:
125%

Supported Services:
Power BI

Formulas:

section Section1;

shared TTCIBD001220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TTCIBD1 = LNDB{[Name="TTCIBD001220"]}[Data],
#"Sorted Rows" = Table.Sort(TTCIBD1,{{"T$ITEM", Order.Descending}, {"T$CITG", Order.Descending}, {"T$DSCB", Order.Descending}})
in
#"Sorted Rows";

shared TTCMCS061220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TTCMCS1 = LNDB{[Name="TTCMCS061220"]}[Data],
#"Sorted Rows" = Table.Sort(TTCMCS1,{{"T$CPLN", Order.Descending}})
in
#"Sorted Rows";

shared TTICPR007220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TTICPR1 = LNDB{[Name="TTICPR007220"]}[Data],
#"Sorted Rows" = Table.Sort(TTICPR1,{{"T$ITEM", Order.Descending}})
in
#"Sorted Rows";

shared TTICST002220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TTICST1 = LNDB{[Name="TTICST002220"]}[Data]
in
TTICST1;

shared TTISFC001220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TTISFC1 = LNDB{[Name="TTISFC001220"]}[Data],
#"Sorted Rows" = Table.Sort(TTISFC1,{{"T$MITM", Order.Descending}})
in
#"Sorted Rows";

shared TWHINR150220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TWHINR1 = LNDB{[Name="TWHINR150220"]}[Data],
#"Sorted Rows" = Table.Sort(TWHINR1,{{"T$ITEM", Order.Descending}})
in
#"Sorted Rows";

shared TWHWMD210220 = let
Source = Oracle.Database("lnprdbmc", [HierarchicalNavigation=true]),
LNDB = Source{[Schema="LNDB"]}[Data],
TWHWMD1 = LNDB{[Name="TWHWMD210220"]}[Data],
#"Sorted Rows" = Table.Sort(TWHWMD1,{{"T$ITEM", Order.Descending}})
in
#"Sorted Rows";

[zoveress]

Are you using the connection over a VPN?

[lcallicutt]

No, I am in the office using the company network.

[Andrej]

@zoveress Hi, I have the same issue too on company VPN. January release is the same. 

[zoveress]

My issue has not been solved. I RDP into a box inside the VPN then I do the reporting from there.

[v-qiuyu-msft]

Would you please share a reproduce machine as suggested before by Herbert? 

This is an issue that is specific to the user’s platform. To get to the bottom of the case, we need you to set up a repro machine and give Microsoft permission to remotely log in, install diagnostics software, and run debugging software.

Best Regards,
Qiuyun Yu

[mjsmith1568]

Hi, I am sorry, but I can not provide access to a computer that has access to the company network via a VPN connection. Is there another way I can help, or another user experiencing the same problem that can provide the access you are looking for?

Regards, Matthew