Forum Discussion
PowerBI Desktop, Exception of type 'System.OutOfMemoryException' was thrown
Modal pop-up:
Something went wrong
Exception of type 'System.OutOfMemoryException' was thrown.
This started recently, two weeks ago or so, on models that have been working successfully for months. However, the cause may have arrived sooner as I haven't been in the desktop for a month or so.
This appears within a minute or two of opening a model, and occurs constantly. It has occured at least two dozen times in the last few days as we've been trying to isolate the cause.
This occurs in the September release and the November release.
So, PowerBI desktop is effectively broken here.
Here are two stack traces from two instances today:
#### STACK TRACE 1 ####
Feedback Type:
Frown (Error)
Timestamp:
2019-12-03T23:16:21.9904168Z
Local Time:
2019-12-03T17:16:21.9904168-06:00
Session ID:
c8927340-fd41-41a9-ae96-e2054f06a741
Release:
September 2019
Product Version:
2.73.5586.1101 (19.09) (x86)
Stack Trace:
at System.Text.StringBuilder.ToString()
at Microsoft.Mashup.Evaluator.PackageEditsHelper.ApplyOrderedEdits(String source, IEnumerable`1 orderedEdits)
at Microsoft.Mashup.Evaluator.EditsPackageSection.get_Text()
at Microsoft.Mashup.Evaluator.TranslateSourceLocationPackageSection.get_Text()
at Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackageSection(BinaryWriter writer, IPackageSection section)
at Microsoft.Mashup.Evaluator.IPackageSerializationExtensions.WriteIPackage(BinaryWriter writer, IPackage package)
at Microsoft.Mashup.Evaluator.RemoteDocumentEvaluator.BeginGetResultMessage.Serialize(BinaryWriter writer)
at Microsoft.Mashup.Evaluator.BinarySerializer.Serialize(Action`1 serializer)
at Microsoft.Mashup.Evaluator.Interface.BufferedMessage.Prepare()
at Microsoft.Mashup.Evaluator.ChannelMessenger.PostWithoutFlowControl(MessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.Post(MessageChannel channel, Message message)
at Microsoft.Mashup.Evaluator.ChannelMessenger.MessageChannel.Post(Message message)
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)
OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528049]
Peak Virtual Memory:
1.72 GB
Private Memory:
698 MB
Peak Working Set:
750 MB
IE Version:
11.864.17763.0
User ID:
2ffd3b4f-eeed-4663-a7ee-72bf619e7c8b
Workbook Package Info:
1* - en-US, Query Groups: 6, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\uj5845dt\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1326055173.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_userFavoriteResourcePackagesEnabled
PBI_tenantOutOfBoxVisualsEnabled
PBI_personalVisualizationPaneEnabled
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI
#### STACK TRACE 2 ####
Feedback Type:
Frown (Error)
Timestamp:
2019-12-03T22:50:57.6269309Z
Local Time:
2019-12-03T16:50:57.6269309-06:00
Session ID:
e4defea5-628c-4623-84dc-87708b2e234b
Release:
September 2019
Product Version:
2.73.5586.1101 (19.09) (x86)
Stack Trace:
at System.String.Split(String[] separator, Int32 count, StringSplitOptions options)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.Snapshot.GetLineFromLineNumber(Int32 lineNumberIndex)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.GetSpan(TokenRange range)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.CreateDefinition(VariableInitializer initializer)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.<VisitLet>b__8_0(VariableInitializer i)
at System.Linq.Enumerable.WhereSelectArrayIterator`2.MoveNext()
at System.Linq.Enumerable.WhereEnumerableIterator`1.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1 collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1 source)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScope..ctor(LanguageScopeKind kind, LanguageScope parent, SnapshotSpan snapshotSpan, IEnumerable`1 definitions)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.AddScope(LanguageScopeKind kind, ISyntaxNode node, IEnumerable`1 definitions)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.VisitLet(ILetExpression let)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitInitializer(VariableInitializer member)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitListElements(IList`1 list)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitLet(ILetExpression let)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.VisitLet(ILetExpression let)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitExpression(IExpression expression)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitExpressionDocument(IExpressionDocument document)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.VisitDocument(IDocument document)
at Microsoft.Mashup.Engine.Interface.ReadOnlyAstVisitor.Visit(Object node)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.LanguageScopeVisitor.Analyze(ITextSnapshot snapshot, IDocument document, LanguageScope libraryScope)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.AnalysisResults..ctor(ITextSnapshot textSnapshot)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.MLanguageService.GetAnalysis(ITextSnapshot snapshot)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.MLanguageService.TokenFromPoint(SnapshotPoint point)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.M.MLanguageService.GetHoverInfo(String text, Int32 cursorIndex)
at Microsoft.Mashup.Client.UI.Shared.Ux.Intellisense.IntellisenseProvider.<>c__DisplayClass20_0.<GetHoverInfoAsync>b__0(Object state)
at Microsoft.Mashup.Host.Document.GlobalizedThreadPool.<>c__DisplayClass2_1.<WrapCallback>b__1()
at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)
OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 en-US)
CLR Version:
4.7 or later [Release Number = 528049]
Peak Virtual Memory:
1.73 GB
Private Memory:
706 MB
Peak Working Set:
736 MB
IE Version:
11.864.17763.0
User ID:
2ffd3b4f-eeed-4663-a7ee-72bf619e7c8b
Workbook Package Info:
1* - en-US, Query Groups: 6, fastCombine: Disabled, runBackgroundAnalysis: False.
Telemetry Enabled:
True
Model Default Mode:
Import
Snapshot Trace Logs:
C:\Users\uj5845dt\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot785023841.zip
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_NewWebTableInference
PBI_showIncrementalRefreshPolicy
PBI_qnaLiveConnect
PBI_userFavoriteResourcePackagesEnabled
PBI_tenantOutOfBoxVisualsEnabled
PBI_personalVisualizationPaneEnabled
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI
We found a solution. We've been running the 32-bit version of Power BI Desktop for reasons of compatibilty with Access. We installed the 64-bit version of Power BI Desktop and these exceptions disappeared. We are willing to forego the compatibility with Access for now, so this works for us.
4 Replies
hi DickMcMullen
Try fully uninstalling Power BI and reinstalling. (Version: 2.75.5649.961)
and also clear %temp% files, then try it again.
https://www.microsoft.com/en-us/download/details.aspx?id=58494
Regards,
Lin
We uninstalled and reinstalled prior to sending in this ticket. We installed November, uninstalled, and then installed September. Both versions are throwing this error, which leads me to believe that the cause may be an incompatibility with a recent Windows 10 update?
hi DickMcMullen
It works well on our side.
Does the issue happen when opening a specific report in Power BI desktop or all reports?
or if you could try other version of power bi desktop.
https://docs.microsoft.com/en-us/power-bi/desktop-latest-update-archive
and if you still have the problem, you'd better create a support ticket in Power BI Support to get further help.
Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".submit a support ticket
Regards,
Lin
We found a solution. We've been running the 32-bit version of Power BI Desktop for reasons of compatibilty with Access. We installed the 64-bit version of Power BI Desktop and these exceptions disappeared. We are willing to forego the compatibility with Access for now, so this works for us.
