Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DickMcMullen
Frequent Visitor

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

1 ACCEPTED SOLUTION
DickMcMullen
Frequent Visitor

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.

View solution in original post

4 REPLIES 4
DickMcMullen
Frequent Visitor

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.

v-lili6-msft
Community Support
Community Support

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

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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 ticketsubmit a support ticket

 

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.