System.OutOfMemoryException crash on Report mostly on PowerQuery

[Anonymous]

Without any change PowerBI crashes constantly, sometimes after opening the report, mostly on PowerQuery-Window

Error Message:
Exception of type 'System.OutOfMemoryException' was thrown.

Stack Trace:
at System.Text.StringBuilder.ToString()
at System.IO.BinaryReader.ReadString()
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.SerializedValueMessage.<>c.<Deserialize>b__9_0(BinaryReader r)
at Microsoft.Mashup.Evaluator.BinarySerializer.Deserialize[T](Byte[] bytes, Func`2 deserializer)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.SerializedValueMessage.Deserialize(BinaryReader reader)
at Microsoft.Mashup.Evaluator.MessageSerializer.Deserialize(BinaryReader reader)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageWithChannel.Deserialize(BinaryReader reader)
at Microsoft.Mashup.Evaluator.MessageSerializer.Deserialize(BinaryReader reader)
at Microsoft.Mashup.Evaluator.StreamMessenger.Read()
at Microsoft.Mashup.Evaluator.StreamMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ErrorTranslatingMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.ChannelMessenger.Read(MessageChannel channel)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Read()
at Microsoft.Mashup.Evaluator.Interface.IMessageChannelExtensions.WaitFor[T](IMessageChannel channel)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.WaitFor(Func`1 condition, Boolean disposing)
at Microsoft.Mashup.Evaluator.RemotePreviewValueSource.PreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.TracingPreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_Value()
at Microsoft.Mashup.Evaluator.Interface.NotifyingPreviewValueSource.get_Value()
at Microsoft.Mashup.Host.Document.Analysis.PackageDocumentAnalysisInfo.PackagePartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
at Microsoft.Mashup.Host.Document.Analysis.CachingDocumentAnalysisInfo.CachingPartitionAnalysisInfo.SetPreviewValue(EvaluationResult2`1 result, Func`1 getStaleSince, Func`1 getSampled)
at Microsoft.Mashup.DocumentHost.DocumentAnalyzer.Analyze(IPartitionAnalysisInfo partitionInfo, AccessRecorder recorder, EvaluationResult2`1 result, Action`1 callback)
at Microsoft.Mashup.DocumentHost.DocumentAnalyzer.<>c__DisplayClass5_1.<BeginAnalyzeDocumentPartition>b__0(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.DocumentEvaluator.<>c__DisplayClass7_0`1.<BeginGetResult>b__0(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose(Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.Interface.EvaluationResultExtensions.InvokeThenOnDispose[T](Action`1 callback, EvaluationResult2`1 result, Action action)
at Microsoft.Mashup.Evaluator.LimitedDocumentEvaluatorFactory.Evaluation`1.Complete(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation`1.TryComplete(EvaluationResult2`1 result)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.PreviewValueSourceRemoteEvaluation.GetResult(Boolean enableFirewall)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.RemoteEvaluation.Evaluate(Boolean enableFirewall)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.EvaluationThread(Object state)
at Microsoft.Mashup.Evaluator.GlobalizedEvaluatorThreadPool.<>c__DisplayClass1_0.<Start>b__0(Object s)
at Microsoft.Mashup.Evaluator.EvaluatorThreadPool.EvaluatorThread(Object state)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass3_0.<CreateThreadStart>b__0(Object o)
at Microsoft.Mashup.Evaluator.SafeThread2.<>c__DisplayClass9_0.<CreateAction>b__0(Object o)

[v-qiuyu-msft]

Hi @Anonymous, 

Does the issue happen when opening a specific report in Power BI desktop or all reports? 

Which steps do you take then cause the issue in PowerQuery-Window? 

Please update Power BI desktop to the latest version 2.71.5523.821 then test again. When you run the Power BI desktop, please check the memory usage in Task Manager.  

Best Regards,
Qiuyun Yu

[Anonymous]

Hi!
Directly after opening it crashes, sometimes it stays stable and I click on "Edit Query", window opens and crashes after that - you can not do anything.
It is on one particual report, but that worked already...

I am on 2.70.5494.761  - I will update and look if it helps...
Oliver

[Anonymous]

with 2.71.5523.821 it seems to be gone - resolved (by now)