There's not enough memory to complete this operation

[hansei]

I have a report that was working fine. Now, a visual will not display with the message: "There's not enough memory to complete this operation. Please try again when more memory might be available." I don't think system memory is actually the problem.

System Resources

The problem happens as soon as the table visual has a related field in it, but doesn't happen with all related fields. e.g. There is a many-to-one relationship between Charges and Claims, and a many-to-one between Claims and Patients. If the table has Charges[Claim ID] (the foreign key) in a column and a field from the Claims table is added, the table fails to display with the error message. However, if a field from the Patients table is added instead, the table displays just fine. Model below, and some other details below that.

Model Charges->Claims->Patients

Feedback Type:
Frown (Error)

Timestamp:
2020-01-07T23:48:55.8440151Z

Local Time:
2020-01-07T15:48:55.8440151-08:00

Session ID:
53e7fade-7bac-4ed1-a854-2af6f772a64d

Release:
September 2019

Product Version:
2.73.5586.1101 (19.09) (x64)

OS Version:
Microsoft Windows NT 10.0.18362.0 (x64 en-US)

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

Peak Virtual Memory:
66.8 GB

Private Memory:
5.48 GB

Peak Working Set:
6.02 GB

IE Version:
11.535.18362.0

User ID:
41aab898-e9be-49fc-b017-0e6cd4647cda

Workbook Package Info:
1* - en-US, Query Groups: 18, fastCombine: Enabled, runBackgroundAnalysis: False.

Telemetry Enabled:
True

Model Default Mode:
Import

Snapshot Trace Logs:
C:\Users\Frank\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot387944098.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:
100%

Supported Services:
Power BI

[hansei]

I ended up rebuilding from a previous save, and not trying to diagnose or fix.

[v-shex-msft]

Hi @hansei,

How many records do you get data to Power bi side? How many columns your tables have?
If your tables have too many columns, please try to remove unused columns to increase loading and calculation performances and reduce memory cost.

In addition, any nested iterator calculation in your calculated column or measure?

They can cause performance issues and spend more memory resources. (e.g. nested three iterators of 1k row tables will multiply the calculation amount to 1k*1k*1k=100m)

In addition, you can also take a look at following link about 'not enough memory' issue:

Power BI - OLAP Import 

Regards,
Xiaoxin Sheng

[amitchandak]

Can you check by increasing the virtual memory of your system?

[hansei]

Not a VM