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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
NavinSinghsays
New Member

Couldn't load model schema

Feedback Type:
Frown (Error)

Timestamp:
2018-08-21T19:52:05.2103939Z

Local Time:
2018-08-22T01:22:05.2103939+05:30

Session ID:
9ba3c4b2-5bbc-44d7-99a2-1c58873d8b8f

Release:
August, 2018

Product Version:
2.61.5192.601 (18.08) (x64)

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.5.1 or later [Release Number = 378758]

Peak Virtual Memory:
1.85 GB

Private Memory:
307 MB

Peak Working Set:
444 MB

IE Version:
9.0.8112.16421

User ID:
b0e97634-d2de-45b4-89aa-9cf45a2139e2

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

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Navin\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1054722724.zip

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_variationUIChange
PBI_canvasTooltips
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_compositeModels
PBI_DB2DQ

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

Formulas:


section Section1;

shared financials = let
Source = Excel.Workbook(File.Contents("C:\Users\Navin\Downloads\Financial Sample.xlsx"), null, true),
financials_Table = Source{[Item="financials",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(financials_Table,{{"Segment", type text}, {"Country", type text}, {"Product", type text}, {"Discount Band", type text}, {"Units Sold", type number}, {"Manufacturing Price", Int64.Type}, {"Sale Price", Int64.Type}, {"Gross Sales", type number}, {"Discounts", type number}, {" Sales", type number}, {"COGS", type number}, {"Profit", type number}, {"Date", type date}, {"Month Number", Int64.Type}, {"Month Name", type text}, {"Year", Int64.Type}})
in
#"Changed Type";

shared Sheet1 = let
Source = Excel.Workbook(File.Contents("C:\Users\Navin\Downloads\Financial Sample.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",{{"Segment", type text}, {"Country", type text}, {"Product", type text}, {"Discount Band", type text}, {"Units Sold", type number}, {"Manufacturing Price", Int64.Type}, {"Sale Price", Int64.Type}, {"Gross Sales", type number}, {"Discounts", type number}, {" Sales", type number}, {"COGS", type number}, {"Profit", type number}, {"Date", type date}, {"Month Number", Int64.Type}, {"Month Name", type text}, {"Year", Int64.Type}})
in
#"Changed Type";

1 ACCEPTED SOLUTION

The issue is resolved now as I updated my OS.

Thank You

View solution in original post

2 REPLIES 2
v-shex-msft
Community Support
Community Support

Hi @NavinSinghsays,

 

Is this issue appears on desktop side or service side?


Can you please provide more details informations about this?(e.g. error trace log, snapshots, detail operations steps you done when the issue appears...)

 

It will be help for troubleshooting.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

The issue is resolved now as I updated my OS.

Thank You

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.