POWERBI system out of memory exception

[AMWILLEMS]

Dear all,

I had this issue on my former laptop and tried to solve this with changing the bits version installed on my pc.

Sadly enough I was not able to solve the problem like this. I saw though that my computer was really using a lot of memory to make POWER BI work.

So I ordered a new pc with lots of memory inside to finally be able to use POWER BI, to end up with the same issues.

I load two excel files into power BI, I sort some colums A to Z,  and I get the error message again.

Please advise, as I was so keen on using this program after a course and find me now ending up with a broken system.

Thanks a lot for your help,

I have now a 32 bits system of power bi and office

PC is windows 10, i7 processor, 64 bits and 16GB RAM.

Thought this would be sufficient and not the problem.

Feedback Type:
Frown (Error)

Timestamp:
2019-04-11T09:39:27.7845005Z

Local Time:
2019-04-11T11:39:27.7845005+02:00

Session ID:
e1562d25-757f-4f5e-85e6-1480321f967b

Release:
December 2018

Product Version:
2.65.5313.1381 (18.12) (x86)

Stack Trace:
   at Microsoft.Mashup.Engine1.Runtime.Keys.New(String[] keys)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForRecord(IRecordExpression record)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForExpression(IExpression expression)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForThrow(IThrowExpression throwExpr)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.CreateValueForExpression(IExpression expression)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass4.<CreateValueForList>b__3(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.ListValue.DemandArrayListValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Language.ValueCreator.<>c__DisplayClass11.<>c__DisplayClass13.<CreateValueForTable>b__10(Int32 columnIndex)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.DemandRecordValue.get_Item(Int32 index)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.get_Item(String field)
   at Microsoft.Mashup.Engine1.Runtime.RecordValue.Microsoft.Mashup.Engine.Interface.IRecordValue.get_Item(String index)
   at Microsoft.Mashup.Host.Document.FormulaResults.TypeResult.InferFieldTypes(IEngine engine, IRecordValue row, BitArray columnsToInfer)
   at Microsoft.Mashup.Host.Document.FormulaResults.TypeResult.InferColumnTypes(IEngine engine, ITableValue table, TypeResult[] staticColumnTypes, Int32 numberOfRowsToInspect)
   at Microsoft.Mashup.Host.Document.FormulaResults.TableResult..ctor(IEngine engine, IValue value)
   at Microsoft.Mashup.Host.Document.FormulaResult.FromValue(IEngine engine, IValue value, ITypeValue structureDefinedType)
   at Microsoft.Mashup.Host.Document.Evaluation.ValueEvaluationResult.get_FormulaResult()
   at Microsoft.Mashup.Host.Document.Preview.AnalysisPreviewResult.TryCreate(ContentStorage contentStorage, PackageEditor packageEditor, MetadataSet metadataSet, Int32 skipCount, Int32 takeCount, Nullable`1 clipCount, PreviewResult& previewResult)
   at Microsoft.Mashup.Host.Document.Preview.PreviewManager.TryGetPreviewResult(PackageEditor packageEditor, MetadataSet metadataSet, Int32 skipCount, Int32 takeCount, Nullable`1 clipCount, PreviewResult& previewResult)
   at Microsoft.Mashup.Host.Document.Preview.PreviewManager.GetPreviewResult(Trace trace, PackageEditor packageEditor, PreviewReference previewReference)
   at Microsoft.Mashup.Client.UI.Shared.HtmlControls.QueryStatusBarHtmlControl.<SetQueryResultDetailsUsingEvaluation>b__1(PreviewReference previewReference)
   at Microsoft.Mashup.Host.Document.Evaluation.PreviewEvaluationQueue.<>c__DisplayClass25.<OnPreviewComplete>b__23()
   at Microsoft.Mashup.Host.Document.ExceptionHandlerExtensions.HandleExceptions(IExceptionHandler exceptionHandler, Action action)

OS Version:
Microsoft Windows NT 10.0.17763.0 (x64 nl-NL)

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

Peak Virtual Memory:
1.65 GB

Private Memory:
701 MB

Peak Working Set:
711 MB

IE Version:
11.134.17763.0

User ID:
040e3670-eb59-46e9-b5ee-abb5f4f21efe

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

Telemetry Enabled:
True

Model Default Mode:
Empty

Snapshot Trace Logs:
C:\Users\amwillems\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot2099930820.zip

Disabled Preview Features:
PBI_shapeMapVisualEnabled
MIntellisense
PBI_SpanishLinguisticsEnabled
PBI_PdfImport
PBI_ColumnProfiling
PBI_variationUIChange
PBI_PythonSupportEnabled
PBI_showIncrementalRefreshPolicy
PBI_showManageAggregations
PBI_FuzzyMatching
PBI_EnableWebDiagramView
PBI_improvedFilterExperience
PBI_qnaLiveConnect

Disabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-yulgu-msft]

Hi @AMWILLEMS ,

Did you import large dataset into Power BI desktop? Please uncheck "Allow data preview to download in nthe backgroup" and check "Enable parallel loading of tables", test if this problem persists.

Besides, please update your desktop to the latest release Version: 2.68.5432.661 64-bit (April 2019) for a try.

Best regards,

Yuliana Gu

[AMWILLEMS]

Hello Yuliana Gu,

Thanks for the suggestions. I will try changing the options.

Paralel loading was already checked on, but I can uncheck "Allow data preview to download in the background"

Updating the software: I will do that as well, but I need to rely on our IT department as I do not have the license to do so.

I do not think it is a big database: 200 lines and 98 columns, so I do not realy believe in this as a cause.  I am not doing rocket science either,  currently I am  just using the program as a way of saving some re-organising steps in the database  and adding conditional colums.

kind regards,

Anne-Marie Willems

 I wi

[AMWILLEMS]

Hi all,

I opened my file again, added two custom colums, sorted my data...

And again I got an error sytem out of memory, this time with the message unhandled exception.

I was just deleting some sorting orders, to keep the actions in my query editior clean, if I want to repeat them on a new dataset.

The software was not updated to the latest version yet, but the other options were changed.

What could be the problem? I tried reverting the excel file into a csv file before loading it into power BI but that did not do the trick either.

All help is appreciated.

Anne-Marie Willems

[v-yulgu-msft]

Hi @AMWILLEMS ,

I was not able to replicate this problem on my side. I need to know detailed repro steps that were applied in Query Editor, as I supposed you sorted columns in Query Editor mode.

If possible, please send me a sample .pbix file which can repro this problem. Remember to avoid loading sensitive data into file before sharing.

Best regards,

Yuliana Gu