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