PowerBI Problem



  • 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



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



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



  • @jmoore updated already



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



  • 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



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



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


Log in to reply