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.



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


Log in to reply