ปัญหาการใช้งานPower BI

Feedback Type:

Frown (Error)

Error Message:

An internal error prevented loading the model schema associated with this report. Please try again later. If the issue persists, contact Power BI support.

Stack Trace:

Host:

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModel(Stream modelStream, IFeatureSwitchProvider featureSwitchProvider)

at Microsoft.PowerBI.ReportingServicesHost.ModelMetadataProvider.GetEngineDataModel(ModelMetadataRequest request, IFeatureSwitchProvider featureSwitchProvider, Func`3 parse)

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModelImpl(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior)

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.HandleModelRetrievalExceptionsT

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.GetEngineDataModelAndHandleExceptions(IPowerViewHandler powerViewHandler, String databaseID, String maxModelMetadataVersion, Nullable`1 translationsBehavior)

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.<>c__DisplayClass34_0.<TryGetEngineDataModel>b__0()

at Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils.TryGetStructureImplT

JavaScript:ShowErrorDialog

at ErrorHostService.showErrorDialogCore(args)

Invocation Stack Trace:

at Microsoft.Mashup.Host.Document.ExceptionExtensions.GetCurrentInvocationStackTrace()

at Microsoft.Mashup.Client.UI.Shared.StackTraceInfo..ctor(String exceptionStackTrace, String invocationStackTrace, String exceptionMessage)

at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.GetStackTraceInfo(Exception e)

at Microsoft.PowerBI.Client.Windows.Telemetry.PowerBIUserFeedbackServices.ReportException(IWindowHandle activeWindow, IUIHost uiHost, FeedbackPackageInfo feedbackPackageInfo, Exception e, Boolean useGDICapture)

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.<>c__DisplayClass14_0.<HandleException>b__0()

at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.PowerBI.Client.PowerBIUnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.PowerBI.Client.Windows.Utilities.PowerBIFormUnexpectedExceptionHandler.HandleException(Exception e)

at Microsoft.PowerBI.Client.Windows.ErrorHostService.<>c__DisplayClass6_0.<ShowErrorDialogCore>b__0()

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Delegate.DynamicInvokeImpl(Object[] args)

at System.Windows.Forms.Control.InvokeMarshaledCallbackDo(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbackHelper(Object obj)

at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)

at System.Windows.Forms.Control.InvokeMarshaledCallbacks()

at System.Windows.Forms.Control.MarshaledInvoke(Control caller, Delegate method, Object[] args, Boolean synchronous)

at System.Windows.Forms.Control.Invoke(Delegate method, Object[] args)

at System.Windows.Forms.WindowsFormsSynchronizationContext.Send(SendOrPostCallback d, Object state)

at Microsoft.PowerBI.Client.Windows.Services.UIBlockingService.AllowModalDialogs(Action action)

at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.<>c__DisplayClass14_0.<ExecuteOnUIThreadAndHandlePromise>b__0()

at Microsoft.PowerBI.Client.Windows.HostServiceDispatcher.ExecuteOnUIThreadAndHandlePromiseT

at System.RuntimeMethodHandle.InvokeMethod(Object target, Object[] arguments, Signature sig, Boolean constructor)

at System.Reflection.RuntimeMethodInfo.UnsafeInvokeInternal(Object obj, Object[] parameters, Object[] arguments)

at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

at Microsoft.PowerBI.Client.Windows.WebView2.WebView2Interop.InvokeCs(InteropCall call)

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

at System.EventHandler`1.Invoke(Object sender, TEventArgs e)

at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

at System.Windows.Forms.UnsafeNativeMethods.DispatchMessageW(MSG& msg)

at System.Windows.Forms.Application.ComponentManager.System.Windows.Forms.UnsafeNativeMethods.IMsoComponentManager.FPushMessageLoop(IntPtr dwComponentID, Int32 reason, Int32 pvLoopData)

at System.Windows.Forms.Application.ThreadContext.RunMessageLoopInner(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Application.ThreadContext.RunMessageLoop(Int32 reason, ApplicationContext context)

at System.Windows.Forms.Form.ShowDialog(IWin32Window owner)

at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModalT

at Microsoft.PowerBI.Client.Program.<>c__DisplayClass6_0.<RunApplication>b__0()

at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.<HandleExceptionsWithNestedTasks>b__0()

at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

at Microsoft.PowerBI.Client.Program.RunApplication(String[] args)

at Microsoft.PowerBI.Client.Program.Main(String[] args)

PowerBINonFatalError:

{"AppName":"PBIDesktop","AppVersion":"2.124.2028.0","ModuleName":null,"Component":"Microsoft.PowerBI.ExploreHost.Utils.ExploreHostUtils","Error":null,"MethodDef":"GetEngineDataModel","ErrorOffset":"","ErrorCode":""}

Snapshot Trace Logs:

C:\Users\nuals\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot8d3d522f-f25b-4a12-bc61-f1eec437ed83.zip

Model Default Mode:

Import

Model Version:

PowerBI_V3

Performance Trace Logs:

C:\Users\nuals\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:

PBI_sparklines

PBI_scorecardVisual

PBI_NlToDax

PBI_fieldParametersSuperSwitch

PBI_setLabelOnExportPdf

PBI_dynamicFormatString

PBI_oneDriveSave

PBI_oneDriveShare

PBI_newCard

PBI_buttonSlicerAuthoring

Disabled Preview Features:

PBI_shapeMapVisualEnabled

PBI_SpanishLinguisticsEnabled

PBI_qnaLiveConnect

PBI_b2bExternalDatasetSharing

PBI_enhancedTooltips

PBI_angularRls

PBI_onObject

PBI_backstageUI

PBI_useModernPublishDialogs

PBI_gitIntegration

PBI_modelExplorer

PBI_daxQueryView

PBI_aiNarrativesVisual

PBI_qnaImproveLsdlCopilot

Disabled DirectQuery Options:

TreatHanaAsRelationalSource

Cloud:

GlobalCloud

PowerBIUserFeedbackServices_IsReported:

True

Formulas:

section Section1;

shared Summary = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Summary\_Sheet = Source{[Item="Summary",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Summary\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Branch", type text}, {"Target", Int64.Type}, {"Target 1-9", Int64.Type}, {"Actual 1-9", Int64.Type}, {"Target 1-16", Int64.Type}, {"Actual 1-16", Int64.Type}, {"Target 1-23", Int64.Type}, {"Actual 1-23", Int64.Type}, {"Actual", Int64.Type}, {"Different", Int64.Type}}) 

in

#"Changed Type"; 

shared Parq = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Parq\_Sheet = Source{[Item="Parq",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Parq\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type"; 

shared Mega = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Mega\_Sheet = Source{[Item="Mega",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Mega\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type"; 

shared Groove = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Groove\_Sheet = Source{[Item="Groove",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Groove\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type"; 

shared Festival = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Festival\_Sheet = Source{[Item="Festival",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Festival\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type"; 

shared Crystal = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

Crystal\_Sheet = Source{[Item="Crystal",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(Crystal\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type"; 

shared All = let

Source = Excel.Workbook(File.Contents("A:\ยอดขาย\สรุปยอดขาย\Feb.2024.xlsx"), null, true), 

All\_Sheet = Source{[Item="All",Kind="Sheet"]}[Data], 

#"Promoted Headers" = Table.PromoteHeaders(All\_Sheet, [PromoteAllScalars=true]), 

#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"วันที่", type text}, {"สาขา", type text}, {"ชื่อพนักงาน", type text}, {"หมวดสินค้า", type text}, {"ชื่อสินค้า", type text}, {"จำนวน", Int64.Type}, {"ยอดรวม", type number}}) 

in

#"Changed Type";