Feedback Type:
Frown (Error)
Error Message:
A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread.
Stack Trace:
Stack Trace Message:
A Task's exception(s) were not observed either by Waiting on the Task or accessing its Exception property. As a result, the unobserved exception was rethrown by the finalizer thread.
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.Mashup.Client.UI.Shared.FeedbackErrorInfo..ctor(String message, Exception exception)
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__DisplayClass1.<HandleException>b__0()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass3.<SendAndMarshalExceptions>b__0(Object null)
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.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
at System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)
at System.Windows.Forms.Control.InvokeMarshaledCallback(ThreadMethodEntry tme)
at System.Windows.Forms.Control.InvokeMarshaledCallbacks()
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
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.WebDialogs.WebDialogBase`1.ShowModal(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClassb.<Main>b__0()
at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass7.<HandleExceptionsWithNestedTasks>b__6()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
at Microsoft.PowerBI.Client.Program.Main(String[] args)
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\paulor01\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1755528673.zip
Performance Trace Logs:
C:\Users\paulor01\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
CustomConnectors
PBI_qnaExplore
PBI_variationUIChange
PBI_canvasTooltips
Disabled Preview Features:
PBI_newFromWeb
PBI_SpanishLinguisticsEnabled
AdobeAnalytics_UseHierarchicalNavigation
PBI_showIncrementalRefreshPolicy
Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
Formulas:
section Section1;
shared Query1 = //Create Date Dimension
(StartDate as date, EndDate as date)=>
let
//Capture the date range from the parameters
StartDate = #date(Date.Year(StartDate), Date.Month(StartDate),
Date.Day(StartDate)),
EndDate = #date(Date.Year(EndDate), Date.Month(EndDate),
Date.Day(EndDate)),
//Get the number of dates that will be required for the table
GetDateCount = Duration.Days(EndDate - StartDate),
//Take the count of dates and turn it into a list of dates
GetDateList = List.Dates(StartDate, GetDateCount,
#duration(1,0,0,0)),
//Convert the list into a table
DateListToTable = Table.FromList(GetDateList,
Splitter.SplitByNothing(), {"Date"}, null, ExtraValues.Error),
//Create various date attributes from the date column
//Add Year Column
YearNumber = Table.AddColumn(DateListToTable, "Year",
each Date.Year([Date])),
//Add Quarter Column
QuarterNumber = Table.AddColumn(YearNumber , "Quarter",
each "Q" & Number.ToText(Date.QuarterOfYear([Date]))),
//Add Week Number Column
WeekNumber= Table.AddColumn(QuarterNumber , "Week Number",
each Date.WeekOfYear([Date])),
//Add Month Number Column
MonthNumber = Table.AddColumn(WeekNumber, "Month Number",
each Date.Month([Date])),
//Add Month Name Column
MonthName = Table.AddColumn(MonthNumber , "Month",
each Date.ToText([Date],"MMMM")),
//Add Day of Week Column
DayOfWeek = Table.AddColumn(MonthName , "Day of Week",
each Date.ToText([Date],"dddd"))
in
DayOfWeek;
shared #"CCares + Class 07 05 2018" = let
Source = Excel.Workbook(File.Contents("C:\Users\paulor01\Desktop\Projeto OTIF OM\DashBase\02.CustomerIndex.xlsx"), null, true),
#"CCares + Class 07.05.2018_Sheet" = Source{[Item="CCares + Class 07.05.2018",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"CCares + Class 07.05.2018_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Customer Code", type text}, {"Customer Name", type text}, {"Segment", type text}, {"Region", type text}, {"Sales Organization", type text}, {"Customer Classification", type text}, {"Customer Care", type text}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"Customer Code", Order.Ascending}}),
#"Filtered Rows" = Table.SelectRows(#"Sorted Rows", each ([Customer Code] <> null)),
#"Sorted Rows1" = Table.Sort(#"Filtered Rows",{{"Customer Name", Order.Ascending}})
in
#"Sorted Rows1";
shared #"Material Atualizado" = let
Source = Excel.Workbook(File.Contents("C:\Users\paulor01\Desktop\Projeto OTIF OM\DashBase\03.MaterialIndex.xlsx"), null, true),
#"Material Atualizado_Sheet" = Source{[Item="Material Atualizado",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Material Atualizado_Sheet", [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Material", type text}, {"Material Description", type text}, {"Family", type text}, {"Model", type text}, {"Factory", type text}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"Material", Order.Ascending}})
in
#"Sorted Rows";
shared Database = let
Source = Excel.Workbook(File.Contents("C:\Users\paulor01\Desktop\Projeto OTIF OM\DashBase\OTIF_new.xlsx"), null, true),
DB_Table = Source{[Item="DB",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(DB_Table,{{"Cust Code", type text}, {"Order", type text}, {"Item", type text}, {"Incoterm", type text}, {"Itinerary", type text}, {"Cond. Expe", type text}, {"Material", type text}, {"Negotiated Dt", type date}, {"Delivery Dt", type date}, {"Tolerance", Int64.Type}, {"Delay", Int64.Type}, {"Reason", type text}, {"Sales Org.", type text}, {"IF", Int64.Type}, {"OT", Int64.Type}, {"OTIF", Int64.Type}}),
#"Sorted Rows" = Table.Sort(#"Changed Type",{{"Cust Code", Order.Ascending}})
in
#"Sorted Rows";
shared Metrics = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMlSKjQUA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", Int64.Type}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"})
in
#"Removed Columns";
shared #"Errors in CCares + Class 07 05 2018" = let
Source = #"CCares + Class 07 05 2018",
#"Added Index" = Table.AddIndexColumn(Source, "Row Number" ,1),
#"Kept Errors" = Table.SelectRowsWithErrors(#"Added Index", {"Customer Code", "Customer Name", "Segment", "Region", "Sales Organization", "Customer Classification", "Customer Care"}),
#"Reordered Columns" = Table.ReorderColumns(#"Kept Errors", {"Row Number", "Customer Code", "Customer Name", "Segment", "Region", "Sales Organization", "Customer Classification", "Customer Care"}),
Segment = #"Reordered Columns"{0}[Segment]
in
Segment
;
I get that pop up error quite often, why does it happen?
