not enough memory

[Faber13]

hello everyone, I have the error below and I don't know how to solve it:

Feedback Type:
Frown (Error)

Timestamp:
2022-12-10T17:31:19.1884874Z

Local Time:
2022-12-10T14:31:19.1884874-03:00

Session ID:
62d79667-e700-40db-a057-572d04593fb9

Release:
August 2022

Product Version:
2.108.603.0 (22.08) (x64)

OS Version:
Microsoft Windows NT 10.0.19044.0 (x64 pt-BR)

CLR Version:
4.8 or later [Release Number = 528372]

Peak Virtual Memory:
70.6 GB

Private Memory:
593 MB

Peak Working Set:
904 MB

IE Version:
11.789.19041.0

User ID:
44872f21-e84f-48b6-8068-725f35a33703

Workbook Package Info:
1* - pt-BR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Import

Model Version:
PowerBI_V3

Enabled Preview Features:
PBI_enableWebView2
PBI_mobileAuthoringFormattingUI
PBI_sparklines
PBI_scorecardVisual
PBI_fieldParametersSuperSwitch

Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_qnaLiveConnect
PBI_azureMapVisual
PBI_compositeModelsOverAS
PBI_enhancedTooltips
PQ_WebView2Connector

Disabled DirectQuery Options:
TreatHanaAsRelationalSource

Cloud:
GlobalCloud

DPI Scale:
100%

Supported Services:
Power BI

[v-yetao1-msft]

Hi @Faber13 

From the information you have provided, it is not possible to determine the cause of the problem. What operation are you doing when this error is reported? Does this error occur on Desktop or Service? What is the corresponding version? Was there a similar error reported when you did this operation before?

Best Regards,
Community Support Team _ Ailsa Tao

[Faber13]

@v-yetao1-msft  this is the first time this has happened (desktop), I tried to make an accumulated measure (the database is small - 80 thousand lines) 

measures below:

var nfs = 'Medidas Nfs'[Nfs Distintas]
var nfstotal = CALCULATE('Medidas Nfs'[Nfs Distintas], ALLSELECTED(Dfornecedor))
var nfsacumuladas =
CALCULATE(
[Nfs Distintas],
FILTER(ALLSELECTED(Dfornecedor),
'Medidas Nfs'[Nfs Distintas] >= nfs))
return
nfsacumuladas

Acumulado =
var cont = [TOP NFS ranking acumulado]
var result =
CALCULATE( 'Medidas Nfs'[Nfs Distintas], TOPN( [TOP NFS ranking acumulado], ALLSELECTED(Dfornecedor), 'Medidas Nfs'[Nfs Distintas]))
return
result

[v-yetao1-msft]

Hi @Faber13 

Due to I don't have access to your data source, I couldn't do some research in Power Query.

Here I will give you some advice.

1. 

Please try to turn off the 'relationship detect' options to disable auto detect the table relationships.

For reference: Create and manage relationships in Power BI Desktop 

2.

 In the Options and setting disable Auto Date time option ,

Increase Cache. File -> Options & setting -> Option -> Data load

Increase virtual memory of the system. Sometimes C drive does not have enough space to expand. if you other drive add Virtual memory there.

Refer to these setting: https://www.thebiccountant.com/speedperformance-aspects/

3. 

How many records are your data table hosted? Any complex expressions calculation(multiple iterators, nested cross table looping calculation ....) and advanced operation(merge, combine, reference, invoke custom functions, recursion...) existed in Dax or query editor side?

For reference:

Optimizing nested iterators in DAX 

Recursive Functions in Power BI / Power Query 

They may affect the performance and spend a huge amount of system resources.

You can also take a look at the following document about performance tips:

For reference: Optimization guide for Power BI 

4. You can try to use Query Diagnostics or Performance Analyzer to monitor your Power BI performance.

For reference: Monitor report performance in Power BI

5. Please download the latest Power BI Desktop version and try again.

Download by this link: Link

Best Regards,
Community Support Team _ Ailsa Tao