b__10() at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction) at Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_0.

b__1() at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.<>c__DisplayClass3_0.b__0() at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Windows.IExceptionHandlerExtensions.HandleExceptionsWithNestedTasks(IExceptionHandler exceptionHandler, Action action) at Microsoft.PowerBI.Client.Program.Main(String[] args) PowerBINonFatalError_ErrorDescription: OutOfMemory Cef Crash Dump0: C:\Users\lizzie.tompsett\AppData\Local\Power BI Desktop\User Data\Crashpad\reports\948bb1bf-7331-4dd5-8f02-8feb3aac30a5.dmp PowerBINonFatalError: {"AppName":"PBIDesktop","AppVersion":"2.85.681.0","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser+<>c__DisplayClass52_1","Error":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.Exceptions.CefProcessCrashedException - OutOfMemory","MethodDef":"b__1","ErrorOffset":"21"} Snapshot Trace Logs: C:\Users\lizzie.tompsett\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot329322371.zip Model Default Mode: Composite Model Version: PowerBI_V3 Is Report V3 Models Enabled: True Performance Trace Logs: C:\Users\lizzie.tompsett\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip Enabled Preview Features: PBI_NewWebTableInference Disabled Preview Features: PBI_shapeMapVisualEnabled PBI_SpanishLinguisticsEnabled PBI_ImportTextByExample PBI_qnaLiveConnect PBI_inlineExplore PBI_dataSearchCuration PBI_azureMapVisual PBI_dataPointLassoSelect PBI_narrativeTextBox Disabled DirectQuery Options: TreatHanaAsRelationalSource Cloud: GlobalCloud Browser name: ExplorationBrowser PowerBIUserFeedbackServices_IsReported: True Formulas: section Section1; shared #"nav Touchscreen Log Entry" = let Source = Sql.Databases("Reports06"), #"PW-vNAV" = Source{[Name="PW-vNAV"]}[Data], #"nav_Touchscreen Log Entry" = #"PW-vNAV"{[Schema="nav",Item="Touchscreen Log Entry"]}[Data], #"Filter Site = Isleham" = Table.SelectRows(#"nav_Touchscreen Log Entry", each [Factory Code] = "ISLEHAM"), #"Filter ShiftDate> 1/1/20" = Table.SelectRows(#"Filter Site = Isleham", each [Shift Date] > #datetime(2020, 6, 1, 0, 0, 0)), #"Col = Start Time" = Table.AddColumn(#"Filter ShiftDate> 1/1/20", "Start Time", each if [Event Type] = 1 then [Date Time] else null), #"Changed Type" = Table.TransformColumnTypes(#"Col = Start Time",{{"Start Time", type datetime}}), #"Col = End Time" = Table.AddColumn(#"Changed Type", "End Time", each if [Event Type] = 2 then [Date Time] else null), #"Changed Type1" = Table.TransformColumnTypes(#"Col = End Time",{{"End Time", type datetime}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type1",{"timestamp"}), #"Col = Shop Floor Serv Code Revd" = Table.AddColumn(#"Removed Columns", "Shop Floor Service Code Revised", each if [Shop Floor Service Code] = "LOT/OUTPUT" and Text.StartsWith([Item No_], "IM") then "WASTE/OUTPUT" else if [Shop Floor Service Code] = "CONSUMPTIO" and Text.StartsWith([Item No_], "IM") then "LOT/CONSUMPTION" else if [Shop Floor Service Code] = "CONSUMPTIO" and Text.StartsWith([Item No_], "PK") then "PACK/CONSUMPTION" else [Shop Floor Service Code]), #"Changed Type2" = Table.TransformColumnTypes(#"Col = Shop Floor Serv Code Revd",{{"Shop Floor Service Code Revised", type text}}) in #"Changed Type2"; shared #"nav Item" = let Source = Sql.Databases("Reports06"), #"PW-vNAV" = Source{[Name="PW-vNAV"]}[Data], nav_Item = #"PW-vNAV"{[Schema="nav",Item="Item"]}[Data] in nav_Item; shared #"Key Measures" = 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}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns"; shared dimDate = 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 [Date = _t]), #"Changed Type" = Table.TransformColumnTypes(Source,{{"Date", Int64.Type}}), #"Col = List of Dates" = Table.AddColumn(#"Changed Type", "Date2", each List.Dates(#date(2017,12,30), 3000, #duration(1,0,0,0))), #"Expanded Date2" = Table.ExpandListColumn(#"Col = List of Dates", "Date2"), #"Removed Columns" = Table.RemoveColumns(#"Expanded Date2",{"Date"}), #"Renamed Columns" = Table.RenameColumns(#"Removed Columns",{{"Date2", "Date"}}), #"Changed Type1" = Table.TransformColumnTypes(#"Renamed Columns",{{"Date", type date}}), #"Col = Index" = Table.AddIndexColumn(#"Changed Type1", "Index", 1, 1), #"Renamed Columns1" = Table.RenameColumns(#"Col = Index",{{"Index", "ID"}}), #"Col = YearID" = Table.AddColumn(#"Renamed Columns1", "YearID", each Number.RoundUp(([ID]/364),0)), #"Changed Type2" = Table.TransformColumnTypes(#"Col = YearID",{{"YearID", Int64.Type}}), #"Col = Adj YearID (W53)" = Table.AddColumn(#"Changed Type2", "Adjusted Year ID", each if [Date] >= #date(2020,12,26) and [Date] <= #date(2021,01,01) then 3 else if [Date] >= #date(2021,12,25) and [Date] <= #date(2021,12,31) then 4 else if [Date] >= #date(2022,12,24) and [Date] <= #date(2022,12,30) then 5 else if [Date] >= #date(2023,12,23) and [Date] <= #date(2023,12,29) then 6 else if [Date] >= #date(2024,12,21) and [Date] <= #date(2024,12,27) then 7 else if [Date] >= #date(2025,12,20) and [Date] <= #date(2025,12,26) then 8 else [YearID]), #"Changed Type8" = Table.TransformColumnTypes(#"Col = Adj YearID (W53)",{{"Adjusted Year ID", Int64.Type}}), #"Removed Columns1" = Table.RemoveColumns(#"Changed Type8",{"YearID"}), #"Renamed Columns3" = Table.RenameColumns(#"Removed Columns1",{{"Adjusted Year ID", "YearID"}}), #"Col = Fin Year" = Table.AddColumn(#"Renamed Columns3", "FinYear", each Date.Year(#date(2018,12,29))+[YearID]-1), #"Col = Week ID" = Table.AddColumn(#"Col = Fin Year", "WeekID", each Number.RoundUp(([ID]/7),0)), #"Changed Type3" = Table.TransformColumnTypes(#"Col = Week ID",{{"FinYear", Int64.Type}, {"WeekID", Int64.Type}}), #"Col = Week of Quarter" = Table.AddColumn(#"Changed Type3", "WeekofQuarter", each [WeekID]-(Number.RoundUp([WeekID]/13)-1)*13), #"Changed Type4" = Table.TransformColumnTypes(#"Col = Week of Quarter",{{"WeekofQuarter", Int64.Type}}), #"Added Custom4" = Table.AddColumn(#"Changed Type4", "Custom.1", each if [WeekID] = 157 then 36 else if [WeekofQuarter]>=1 and [WeekofQuarter]<=4 then ((Number.RoundUp([WeekID]/13)-1)*3+1) else null), #"Replaced Value" = Table.ReplaceValue(#"Added Custom4",null,each if [WeekofQuarter]>=5 and [WeekofQuarter]<=8 then ((Number.RoundUp([WeekID]/13)-1)*3+2) else null,Replacer.ReplaceValue,{"Custom.1"}), #"Replaced Value1" = Table.ReplaceValue(#"Replaced Value",null,each if [WeekofQuarter]>=9 and [WeekofQuarter]<=13 then ((Number.RoundUp([WeekID]/13)-1)*3+3) else null,Replacer.ReplaceValue,{"Custom.1"}), #"Col = MonthID" = Table.RenameColumns(#"Replaced Value1",{{"Custom.1", "MonthID"}}), #"Changed Type5" = Table.TransformColumnTypes(#"Col = MonthID",{{"MonthID", Int64.Type}}), #"Col = Fin Month" = Table.AddColumn(#"Changed Type5", "FinMonth", each if [WeekID] = 157 then 12 else if [WeekID] = 209 then 12 else if [WeekID] = 261 then 12 else if [WeekID] = 313 then 12 else if [WeekID] = 365 then 12 else if [WeekID] = 417 then 12 else ([MonthID] - (Number.RoundUp([MonthID]/12)-1)*12)), #"Col = Fin Week" = Table.AddColumn(#"Col = Fin Month", "FinWeek", each if [WeekID] < 157 then ([WeekID]-(Number.RoundUp([WeekID]/52)-1)*52) else if [WeekID] = 157 then 53 else if [WeekID] = 209 then 52 else if [WeekID] = 261 then 52 else if [WeekID] = 313 then 52 else if [WeekID] = 365 then 52 else if [WeekID] = 417 then 52 else ([WeekID]-(Number.RoundUp([WeekID]/52)-1)*52-1)), #"Col = Calendar Week" = Table.AddColumn(#"Col = Fin Week", "CalendarWeek", each if [WeekID] < 157 then [FinWeek]-1 else if [WeekID] = 157 then 1 else [FinWeek]+1), #"Col = Calendar Month No" = Table.AddColumn(#"Col = Calendar Week", "CalendarMonthNo", each Date.Month([Date])), #"Col = Fin Month Name" = Table.AddColumn(#"Col = Calendar Month No", "FinMonthName", each Date.ToText(#date([FinYear],[FinMonth],1),"MMM")), #"Col = Day of week" = Table.AddColumn(#"Col = Fin Month Name", "DayOfWeek", each Date.ToText([Date],"ddd")), #"Col = Period Code" = Table.AddColumn(#"Col = Day of week", "PeriodCode", each if [FinMonth] <=9 then (Number.ToText([FinYear])& "-P0"& Number.ToText([FinMonth])) else (Number.ToText([FinYear])& "-P"& Number.ToText([FinMonth]))), #"Col = Week Code" = Table.AddColumn(#"Col = Period Code", "WeekCode", each if [FinWeek] <=9 then (Number.ToText([FinYear])& "-W0"& Number.ToText([FinWeek])) else (Number.ToText([FinYear])& "-W"& Number.ToText([FinWeek]))), #"Col = Period No." = Table.AddColumn(#"Col = Week Code", "PeriodNumber", each Text.End([PeriodCode],3)), #"Changed Type6" = Table.TransformColumnTypes(#"Col = Period No.",{{"PeriodNumber", type text}}), #"Col = Week No." = Table.AddColumn(#"Changed Type6", "WeekNumber", each Text.End([WeekCode],3)), #"Changed Type7" = Table.TransformColumnTypes(#"Col = Week No.",{{"WeekNumber", type text}, {"WeekCode", type text}, {"PeriodCode", type text}, {"DayOfWeek", type text}, {"FinMonthName", type text}, {"CalendarMonthNo", Int64.Type}, {"CalendarWeek", Int64.Type}, {"FinWeek", Int64.Type}, {"FinMonth", Int64.Type}}), #"Col = Year ID Mth ID" = Table.AddColumn(#"Changed Type7", "YearIDMonthID", each Number.ToText([YearID])&Number.ToText([MonthID])), #"Sorted Rows" = Table.Sort(#"Col = Year ID Mth ID",{{"Date", Order.Ascending}}), #"Removed Columns2" = Table.RemoveColumns(#"Sorted Rows",{"WeekofQuarter", "CalendarWeek"}), #"Added Custom" = Table.AddColumn(#"Removed Columns2", "Start Of Week", each Number.From(Date.StartOfWeek([Date]))-2), #"Added Custom1" = Table.AddColumn(#"Added Custom", "Start of Week NOW", each Number.From(Date.StartOfWeek(DateTime.LocalNow()))-2), #"Added Custom2" = Table.AddColumn(#"Added Custom1", "Custom", each ([Start Of Week]-[Start of Week NOW])/7), #"Added Custom3" = Table.AddColumn(#"Added Custom2", "Current Week", each if [Custom] = 0 then "Current Week" else "") in #"Added Custom3"; shared #"Key Measures - PPM" = 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}}), #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"Column1"}) in #"Removed Columns"; shared dimTargets = let Source = Excel.Workbook(File.Contents("\\data\data\Company\IFP\CentralProduction\ZDashboard\Isleham Targets.xlsx"), null, true), TARGETS_Sheet = Source{[Item="TARGETS",Kind="Sheet"]}[Data], #"Promoted Headers" = Table.PromoteHeaders(TARGETS_Sheet, [PromoteAllScalars=true]), #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Line", type text}, {"Item", type text}, {"PPM Target", Int64.Type}}), #"Col = LineItem" = Table.AddColumn(#"Changed Type", "LineItem", each Text.Combine({[Line]," ", [Item]})), #"Changed Type1" = Table.TransformColumnTypes(#"Col = LineItem",{{"LineItem", type text}}) in #"Changed Type1";