Problem on publishing

[winpos]

I need help:

Feedback Type:
Frown (Error)

Error Message:
We’re sorry. A problem occurred while rendering the report, and Power BI Desktop will close now. Please restart.

Stack Trace:
at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser.<>c__DisplayClass52_1.<OnRenderProcessTerminated>b__1()

Stack Trace Message:
We’re sorry. A problem occurred while rendering the report, and Power BI Desktop will close now. Please restart.

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__DisplayClass15_0.<HandleException>b__0()
at Microsoft.Mashup.Client.UI.Shared.UnexpectedExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.Utilities.UIBlockingAwareExceptionHandler.HandleException(Exception e)
at Microsoft.PowerBI.Client.Windows.MainWindow.Microsoft.PowerBI.Client.Windows.CefSharpFramework.ICefBrowserHost.OnFatalError(FeedbackActionInfo feedbackActionInfo, Exception e, String knownErrorDetailsUrl)
at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser.<>c__DisplayClass52_1.<OnRenderProcessTerminated>b__1()
at Microsoft.Mashup.Host.Document.SynchronizationContextExtensions.<>c__DisplayClass0_1.<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.Windows.DialogWindowBase.ShowModal(IWindowHandle windowHandle)
at Microsoft.Mashup.Client.UI.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle owner)
at Microsoft.Mashup.Client.UI.Shared.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.Mashup.Client.UI.Shared.Ux.FloatingDialog.FloatingDialog.ShowDialogWithTimeout(IWindowHandle owner, Nullable`1 showTimeout)
at Microsoft.Mashup.Client.UI.Shared.Ux.WindowService.ShowDialogWithTimeout(FloatingDialog dialog, Nullable`1 showTimeout)
at Microsoft.PowerBI.Client.Windows.FloatingDialog.KoPublishDialog.ShowLoadingDialogAndWaitPublishingResult(IWindowService windowService, IUIHost uiHost, IPowerBIWindowServiceFactory windowServiceFactory, ICloudConfigurationManager cloudManager, IPowerBITelemetryService telemetryService, IExceptionHandler exceptionHandler, CancellationTokenSource cancellationTokenSource, IPbixFileInfo fileInfo, LocalizedString title, Task`1 publishTask, Boolean isPremium, Boolean pageRefreshEnabled)
at Microsoft.PowerBI.Client.Windows.PowerBIService.ReportPublisher.<PublishReport>d__13.MoveNext()
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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
at System.Threading.Tasks.AwaitTaskContinuation.RunCallback(ContextCallback callback, Object state, Task& currentTask)
at System.Threading.Tasks.Task.FinishContinuations()
at System.Threading.Tasks.Task`1.TrySetResult(TResult result)
at System.Runtime.CompilerServices.AsyncTaskMethodBuilder`1.SetResult(TResult result)
at Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowserBase.<InvokeScriptAsync>d__23`1.MoveNext()
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.Runtime.CompilerServices.AsyncMethodBuilderCore.MoveNextRunner.Run()
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.WindowManager.ShowModal[T](T dialog, Func`1 showModalFunction)
at Microsoft.PowerBI.Client.Program.<>c__DisplayClass1_0.<Main>b__1()
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.Main(String[] args)

PowerBINonFatalError_ErrorDescription:
ProcessCrashed

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 - ProcessCrashed","MethodDef":"<OnRenderProcessTerminated>b__1","ErrorOffset":"21"}

Snapshot Trace Logs:
C:\Users\pbi\Microsoft\Power BI Desktop Store App\FrownSnapShot552507068.zip

Model Default Mode:
Import

Model Version:
PowerBI_V3

Is Report V3 Models Enabled:
True

Performance Trace Logs:
C:\Users\pbi\Microsoft\Power BI Desktop Store App\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 VIEWERS = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_groups = Source{[Schema="sales138326_beatstats",Item="groups"]}[Data]
in
sales138326_beatstats_groups;

shared Categories = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_stck_categ = Source{[Schema="sales138326_beatstats",Item="stck_categ"]}[Data],
#"Renamed Columns" = Table.RenameColumns(sales138326_beatstats_stck_categ,{{"stca_desc", "Κατηγορία"}})
in
#"Renamed Columns";

shared StockGroups = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_stck_group = Source{[Schema="sales138326_beatstats",Item="stck_group"]}[Data],
#"Renamed Columns" = Table.RenameColumns(sales138326_beatstats_stck_group,{{"stgr_desc", "Γκρουπ"}})
in
#"Renamed Columns";

shared Items = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_stock = Source{[Schema="sales138326_beatstats",Item="stock"]}[Data],
#"Renamed Columns" = Table.RenameColumns(sales138326_beatstats_stock,{{"stck_desc", "Περιγραφή"}})
in
#"Renamed Columns";

shared Branches = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_subsidiaries = Source{[Schema="sales138326_beatstats",Item="subsidiaries"]}[Data],
#"Renamed Columns" = Table.RenameColumns(sales138326_beatstats_subsidiaries,{{"subs_desc", "Point of Sales"}})
in
#"Renamed Columns";

shared Companies = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_companies = Source{[Schema="sales138326_beatstats",Item="companies"]}[Data]
in
sales138326_beatstats_companies;

shared RECEIPTS_COUNT = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [HierarchicalNavigation=true, ReturnSingleDatabase=true]),
sales138326_beatstats = Source{[Schema="sales138326_beatstats"]}[Data],
RECEIPTS_COUNT1 = sales138326_beatstats{[Name="RECEIPTS_COUNT"]}[Data]
in
RECEIPTS_COUNT1;

shared Hours2020_a3 = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_Hours2020a3 = Source{[Schema="sales138326_beatstats",Item="Hours2020a3"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(sales138326_beatstats_Hours2020a3,{{"inma_refer", type text}})
in
#"Changed Type";

shared Hours2020 = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [HierarchicalNavigation=true, ReturnSingleDatabase=true]),
sales138326_beatstats = Source{[Schema="sales138326_beatstats"]}[Data],
Hours1 = sales138326_beatstats{[Name="Hours2020"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Hours1,{{"inma_refer", type text}}),
#"Appended Query" = Table.Combine({#"Changed Type", V_PAST_HOURS_2020})
in
#"Appended Query";

shared V_PAST_HOURS_2020 = let
Source = Sql.Database("DESKTOP-8BCB4EK", "BeatSales"),
dbo_V_PAST_HOURS_2020 = Source{[Schema="dbo",Item="V_PAST_HOURS_2020"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(dbo_V_PAST_HOURS_2020,{{"inma_refer", type text}, {"SalesTime", type time}})
in
#"Changed Type";

shared Hours2020a2_for_append = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_Hours2020a2 = Source{[Schema="sales138326_beatstats",Item="Hours2020a2"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(sales138326_beatstats_Hours2020a2,{{"inma_refer", type text}})
in
#"Changed Type";

shared zita_main = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [HierarchicalNavigation=true, ReturnSingleDatabase=true]),
sales138326_beatstats = Source{[Schema="sales138326_beatstats"]}[Data],
zita_main1 = sales138326_beatstats{[Name="zita_main"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(zita_main1,{{"zita_main_date", type date}})
in
#"Changed Type";

shared #"Dax Functions" = 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"}),
#"Added Index" = Table.AddIndexColumn(#"Removed Columns", "Index", 0, 1)
in
#"Added Index";

shared Shops = let
Source = Excel.Workbook(File.Contents("C:\Users\PBI\Desktop\BeatPowerBI\Beat.xlsx"), null, true),
Shops_Sheet = Source{[Item="Shops",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Shops_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"id", type text}, {"name", type text}, {"url photo", type text}})
in
#"Changed Type";

shared edits = let
Source = Excel.Workbook(File.Contents("C:\Users\PBI\Desktop\BeatPowerBI\Beat edits.xlsx"), null, true),
Διορθώσεις_Sheet = Source{[Item="Διορθώσεις",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(Διορθώσεις_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Group", Int64.Type}, {"Group_1", type text}, {"Category", Int64.Type}, {"Category_2", type text}, {"eidos", type text}, {"perigrafi", type text}, {"Characterizer", type text}}),
#"Removed Duplicates" = Table.Distinct(#"Changed Type", {"eidos"}),
#"Renamed Columns" = Table.RenameColumns(#"Removed Duplicates",{{"Characterizer", "Ν.Κατηγορία"}})
in
#"Renamed Columns";

shared DAXLocal = 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 #"Measures Selection" = let
Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WCk7MSS1W0lFSitWJVgosqYQxff3BrFgA", BinaryEncoding.Base64), Compression.Deflate)), let _t = ((type text) meta [Serialized.Text = true]) in type table [Column1 = _t, Column2 = _t]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}}),
#"Renamed Columns" = Table.RenameColumns(#"Changed Type",{{"Column1", "Measura"}}),
#"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Column2"}),
#"Added Index" = Table.AddIndexColumn(#"Removed Columns", "Index", 1, 1)
in
#"Added Index";

shared Sales = let
Source = MySQL.Database("db63.grserver.gr", "sales138326_beatstats", [ReturnSingleDatabase=true]),
sales138326_beatstats_SALES2020 = Source{[Schema="sales138326_beatstats",Item="SALES2020"]}[Data],
#"Removed Columns" = Table.RemoveColumns(sales138326_beatstats_SALES2020,{"RowLevel"}),
#"Appended Query" = Table.Combine({#"Removed Columns", PAST_SALES})
in
#"Appended Query";

shared PAST_SALES = let
Source = Sql.Database("DESKTOP-8BCB4EK", "BeatSales"),
dbo_PAST_SALES = Source{[Schema="dbo",Item="V_PAST_SALES"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(dbo_PAST_SALES,{{"katastrofes", type number}}),
#"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"RowLevel"}),
#"Changed Type1" = Table.TransformColumnTypes(#"Removed Columns",{{"DateOfSales", type date}})
in
#"Changed Type1";

shared events = let
Source = Excel.Workbook(File.Contents("C:\Users\pbi\Desktop\BeatPowerBI\Beat.xlsx"), null, true),
events_Sheet = Source{[Item="events",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(events_Sheet, [PromoteAllScalars=true]),
#"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Date", type date}, {"Shop", type text}, {"Description ", type text}})
in
#"Changed Type";

[v-yuta-msft]

@winpos ,

I could not reproduce this issue on my side. Make sure power bi desktop has been updated to the latest version. In addtion, if this issue persists, I would suggest you create a support ticket here for further analysis.

 

Regards,

Jimmy Tao