PowerBI Problem

shybrsky

Dear mango team

im facing problem when tried to getdata from excel to my powerBI desktop .
show " couldn't load the model schemas "
i alreadylogged in with my microsoft acc, which already licensed to used PowerBI .

Glad to get ur solution

Thanks
shybs

scottalanmiller

@shybrsky said in PowerBI Problem:

couldn't load the model schemas

Did you select a specific cube? This error can arise from selecting the entire database instead.

jmoore

@shybrsky Also make sure it is updated. They have a new update at least once a month

shybrsky

@jmoore updated already

shybrsky

@scottalanmiller below is my detail error
Feedback Type:
Frown (Error)

Timestamp:
2018-08-08T02:26:45.4206720Z

Local Time:
2018-08-08T09:26:45.4206720+07:00

Session ID:
de9dbf55-aed8-4da0-908d-ebb38f5f24ff

Release:
July, 2018

Product Version:
2.60.5169.4101 (18.07) (x64)

Error Message:
Couldn't load the model schema.

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

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

Peak Virtual Memory:
2.01 GB

Private Memory:
487 MB

Peak Working Set:
636 MB

IE Version:
9.0.8112.16421

User ID:
e24cbe5d-3505-4455-9722-39f0ded027c1

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

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

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
CustomConnectors
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips
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 #"Monitoring Booking & WI-1" = let
Source = Excel.Workbook(File.Contents("D:\OneDrive\DataMobility\Klog Track\NEWTEST\Monitoring Booking & WI Juli 2018 (Ops).xlsx"), null, true),
#"Monitoring Booking & WI-1_Sheet" = Source{[Item="Monitoring Booking & WI-1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Monitoring Booking & WI-1_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"WI Status", type text}, {"Name", type text}, {"Order Received", type datetime}, {"PO Date", type datetime}, {"Date Created", type datetime}, {"Stuffing start Date", type datetime}, {"Stuffing End Date", type datetime}, {"Customer Code", type text}, {"Customer", type text}, {"Customer Reference #", type any}, {"Shipper Name", type text}, {"Shipper Address", type text}, {"Place Of Receipt", type text}, {"Consignee Name", type text}, {"Consignee Address", type text}, {"Place Of Delivery", type text}, {"Container Type", type text}, {"Port Of Loading", type text}, {"Port Of Discharge", type text}, {"Shipping Line", type text}, {"Commodity", type text}, {"Effective Date Start", type datetime}, {"Effective Date End", type datetime}, {"Comm Rate", type any}, {"Sales Rate", type any}, {"No SP", type text}, {"PIC CS East", type text}, {"PIC Sales", type text}, {"Assigned to", type text}, {"KPI Send Wi", type text}, {"Miss KPI Reason", type text}, {"Other Miss KPI Reason", type text}, {"Booking Created", type datetime}, {"Booking Created By", type text}, {"Booking Number", type text}, {"Booking Remark", type text}, {"Booking Status", type text}, {"Miss Create Booking", type text}, {"Other Miss Create Booking", type text}, {"Miss Confirm Booking", type text}, {"Other Miss Confirm Booking", type text}, {"Cancel WI Reason", type text}, {"Other Cancel WI Reason", type text}, {"Nick Cust.", type text}, {"Stuffing date", type date}, {"Booking create date", type text}, {"month", Int64.Type}, {"Age", type number}, {"Cek", type text}})
in
#"Changed Type";

shared Table1 = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i44FAA==", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}})
in
#"Changed Type";

shared #"Monitoring Booking & WI-1 (2)" = let
Source = Excel.Workbook(File.Contents("D:\OneDrive\DataMobility\Klog Track\NEWTEST\Monitoring Booking & WI Juli 2018 (Ops).xlsx"), null, true),
#"Monitoring Booking & WI-1_Sheet" = Source{[Item="Monitoring Booking & WI-1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Monitoring Booking & WI-1_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"WI Status", type text}, {"Name", type text}, {"Order Received", type datetime}, {"PO Date", type datetime}, {"Date Created", type datetime}, {"Stuffing start Date", type datetime}, {"Stuffing End Date", type datetime}, {"Customer Code", type text}, {"Customer", type text}, {"Customer Reference #", type any}, {"Shipper Name", type text}, {"Shipper Address", type text}, {"Place Of Receipt", type text}, {"Consignee Name", type text}, {"Consignee Address", type text}, {"Place Of Delivery", type text}, {"Container Type", type text}, {"Port Of Loading", type text}, {"Port Of Discharge", type text}, {"Shipping Line", type text}, {"Commodity", type text}, {"Effective Date Start", type datetime}, {"Effective Date End", type datetime}, {"Comm Rate", type any}, {"Sales Rate", type any}, {"No SP", type text}, {"PIC CS East", type text}, {"PIC Sales", type text}, {"Assigned to", type text}, {"KPI Send Wi", type text}, {"Miss KPI Reason", type text}, {"Other Miss KPI Reason", type text}, {"Booking Created", type datetime}, {"Booking Created By", type text}, {"Booking Number", type text}, {"Booking Remark", type text}, {"Booking Status", type text}, {"Miss Create Booking", type text}, {"Other Miss Create Booking", type text}, {"Miss Confirm Booking", type text}, {"Other Miss Confirm Booking", type text}, {"Cancel WI Reason", type text}, {"Other Cancel WI Reason", type text}, {"Nick Cust.", type text}, {"Stuffing date", type date}, {"Booking create date", type text}, {"month", Int64.Type}, {"Age", type number}, {"Cek", type text}})
in
#"Changed Type";

shybrsky

hi all ..
just figured out what is my problem due that issue
PowerBI requirements :

Internet Explorer 11 ( Mine still IE 8 , if need to upgrade to 11 , i have to upgrade my Windows 7 to SP 1 )
Windows 7 SP1 ( Mine still original Windows 7 Pro without SP1 )

after complete all requirements , powerBI up to my notebook

Thanks everyone for responding my issue
Shybs

DustinB3403

@shybrsky said in PowerBI Problem:

hi all ..
just figured out what is my problem due that issue
PowerBI requirements :

Internet Explorer 11 ( Mine still IE 8 , if need to upgrade to 11 , i have to upgrade my Windows 7 to SP 1 )

Windows 7 SP1 ( Mine still original Windows 7 Pro without SP1 )

after complete all requirements , powerBI up to my notebook

Thanks everyone for responding my issue
Shybs

You're using Windows 7, pre sp1?? No wonder you're having issues.

DustinB3403

@shybrsky you really should upgrade to Windows 10 if you have to use Windows. I know the PowerBI desktop application is Windows-Only so this is a requirement for many who need to create and edit dashboards.

If you're only viewing content though you can use any modern web browser and operating system you want.

shybrsky

@DustinB3403 its been 2 years. now im using w10 . and no issue