Out of Memory

[GaryWalton]

I'm getting this error when working on reports based on a remote dataset.

Usually occurs within a set number of actions (page changes, bookmark selections, object moves in selection pane etc).

This is the x64 version of desktop but it never addresses more than 3.5gb ram - of 8gb, is this not the memory that the error relates to?

Any pointers if it is different memory?

Feedback Type:
Frown (Error)

Timestamp:
2020-06-04T13:11:11.9129321Z

Local Time:
2020-06-04T14:11:11.9129321+01:00

Session ID:
a6e4fb78-c70e-45f9-8caf-85615b9259ea

Release:
May 2020

Product Version:
2.81.5831.821 (20.05) (x64)

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

PowerBINonFatalError_ErrorDescription:
OutOfMemory

Cef Crash Dump0:
C:\Users\WaltonG\AppData\Local\Power BI Desktop\User Data\Crashpad\reports\b3a802e7-a1db-4424-8c7f-74ed12141938.dmp

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.81.5831.821","ModuleName":"Microsoft.PowerBI.Client.Windows.dll","Component":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.CefWebBrowser+<>c__DisplayClass46_1","Error":"Microsoft.PowerBI.Client.Windows.CefSharpFramework.Exceptions.CefProcessCrashedException - OutOfMemory","MethodDef":"<OnRenderProcessTerminated>b__1","ErrorOffset":"21"}

OS Version:
Microsoft Windows NT 10.0.17134.0 (x64 en-US)

CLR Version:
4.7 or later [Release Number = 461808]

Peak Virtual Memory:
38.9 GB

Private Memory:
814 MB

Peak Working Set:
1.39 GB

IE Version:
11.1488.17134.0

User ID:
6de5f4d5-d841-4c32-88a5-96742ddc47c0

Workbook Package Info:
1* - en-GB, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.

Telemetry Enabled:
True

AS Live Connection:
True

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_showMinervaRibbon
PBI_showMinervaViewNavigator
PBI_hierarchicalSlicerCreation

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_inlineExplore
PBI_realTimeRefresh
PBI_v3ModelsPreview
PBI_relativeTimeSlicer
PBI_dataSearchCuration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Browser name:
ExplorationBrowser

DPI Scale:
100%

Supported Services:
Power BI

[v-yuta-msft]

@GaryWalton ,

This issue should be caused by too many data. How many rows and columns are there in your dataset? And have you created two complex measures or calculate columns?(like interator)

Regards,

Jimmy Tao

[GaryWalton]

Hi @v-yuta-msft 

The remote dataset contains 15-20 million rows across 20 tables and contains many measures.

However, I raise this as the activity I am currently carrying out is rebuilding an existing report (its dataset in the same .pbix file, local) to work with a remote dataset (identical).

The original report, with the local dataset stored in the .pbix file on my machine, has no issues and never displays an 'out of memory' error.

Gary.

[GaryWalton]

To confirm, this is still happening in latest release even after doubling the global options for data cache and Q&A cache to 8192MB

I now experience the error consistently when:

1. Opening the report in PBI desktop.

2. Inserting a Button.

3. Opening the Selection list under 'View'.

4. Copying a group of 3 objects.

Feedback Type:
Frown (Error)

Error Message:
We're sorry. This report ran out of memory, and the application must close.

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

Stack Trace Message:
We're sorry. This report ran out of memory, and the application must close.

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.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.Shared.WebDialogs.WebDialog.<>n__0(IWindowHandle 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:
OutOfMemory

PowerBINonFatalError:
{"AppName":"PBIDesktop","AppVersion":"2.82.5858.1161","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":"<OnRenderProcessTerminated>b__1","ErrorOffset":"21"}

AS Live Connection:
True

Performance Trace Logs:
C:\Users\WaltonG\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip

Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_NewWebTableInference
PBI_qnaLiveConnect
PBI_modelViewASLiveConnect

Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
PBI_inlineExplore
PBI_v3ModelsPreview
PBI_relativeTimeSlicer
PBI_dataSearchCuration

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

Browser name:
ExplorationBrowser

Formulas:

section Section1;

[GaryWalton]

Just carried out an experiment.

On opening the report, task manager shows PBI @1.5GB, with several Cefsharp subprocesses at maximum 300MB. On refreshing the dataset (live connection) there is a minor increase but the settles again.

Upon copying and pasting a simple, built-in line object, one Cefsharp subprocess balloons to over 3GB. At that point, this particular subprocess exceeds a memory allowance which causes the 'out of memory' error.

It seems that I get the opportunity to do ONE THING before having to save and restart, otherwise I get the out of memory error.

PLEASE allow us to set the amount of RAM that the Cefsharp chromium renderer can expand to as even on the desktop application, I am unable to author reports whilst still having over 8GB RAM freely available.

See https://community.powerbi.com/t5/Issues/Avoiding-PowerBi-memory-failure-in-CefSharp-module/idi-p/868... for more info on how this can be resolved.

More information, it seems that by running Power BI as administrator, Cefsharp seems to be a bit more conservative with RAM usage, thought it still creeps up and eventually causes the same error. Jus means that I can do a few more things first.

Further Info: The amount of memory bloat seems to be dependant on the action carried out, it appears that I can move objects into / out of groups many times before the error occurs but as soon as I copy & paste a single object or group of objects, the error will occur 90% of the time.

[Anonymous]

Hello

many thanks for sharing your findings.

We have same issue at some Reports frequently occuring.

Update:

I've opened a idea request: https://ideas.powerbi.com/ideas/idea/?ideaid=3fd9a14e-4cdd-ea11-bf21-281878bd6a00

To add an option within Power BI Desktop client to increase limitation.

Many thanks

Daniel