ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    PowerBI Problem

    IT Discussion
    powerbi excel
    4
    9
    1.8k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • S
      shybrsky
      last edited by scottalanmiller

      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

      jmooreJ 1 Reply Last reply Reply Quote 0
      • scottalanmillerS
        scottalanmiller
        last edited by

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

        S 1 Reply Last reply Reply Quote 0
        • jmooreJ
          jmoore @shybrsky
          last edited by

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

          S 1 Reply Last reply Reply Quote 0
          • S
            shybrsky @jmoore
            last edited by

            @jmoore updated already

            1 Reply Last reply Reply Quote 0
            • S
              shybrsky @scottalanmiller
              last edited by

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

              1 Reply Last reply Reply Quote 0
              • S
                shybrsky
                last edited by

                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

                DustinB3403D 2 Replies Last reply Reply Quote 0
                • DustinB3403D
                  DustinB3403 @shybrsky
                  last edited by

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

                  1 Reply Last reply Reply Quote 0
                  • DustinB3403D
                    DustinB3403 @shybrsky
                    last edited by

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

                    S 1 Reply Last reply Reply Quote 1
                    • S
                      shybrsky @DustinB3403
                      last edited by

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

                      1 Reply Last reply Reply Quote 1
                      • 1 / 1
                      • First post
                        Last post