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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
osinquinvdm
Advocate II
Advocate II

What are the usual cause of memories issues?

For the past 2 days I have been unable to display most visualizations and got an "not enough memory " error message instead.

Sure I have only 8 Gb RAM on this laptop and I have introduced cumulative measures that I suspect to be pretty computation intensive. But:

  • PBI was working like a charm for the past 2 months on that project
  • 2 days ago the visualizations involving the cumulative measures did work (although kind of slow to render)
  • it's crashing on simple visaulizations too (things like simple conditional counts that have nothing to do with the cumulative measures )
  • it's crashing in the cloud too (what's the memory limit there?).

The only other recent change I can think of is making my measure cleaner and easier to read by nesting them.
For example
Nb Actual Requests= CALCULATE([Nb Requests];FILTER('311_Details';'311_Details'[Nature]<>"Information"))
where
Nb Requests= CALCULATE(COUNT('311_Details'[RequestID]);USERELATIONSHIP('311_Details'[Creation Date];AllDates[Date]))

 

  • Is there a known impact of using such measure nesting?
  • Is there a known impact of using USERELATIONSHIP()?

What are the usual cause of memories issues?

3 REPLIES 3
RMDNA
Solution Sage
Solution Sage

I would think the usual cause would be just that - you're running out of memory. Why exactly Power BI doesn't like particular measures or tables or finds certain calculations intensive, I don't know, but whatever the reason, I would just address the what the error calls out - add more memory.

 

I ran into the same issue on my current project - using a particular calcuation from a particular table caused the report to choke and kill all my visuals. The error is too general to hunt for a specific reason, so I chose to bypass the issue and just upped my laptop memory from 4GB to 20GB. Not an elegant or necssarily cost-effective solution (though memory is really cheap), but Power BI doesn't complain anymore.

Thanks @RMDNA for sharing your experience. This is actually the first solution that came to my mind. Unfortunately my main concern is that the dashboard is going to be consumed in the cloud and my tests show that I am having the same behaviour.

As long as I'm looking at a very small date window, it is slow but it work. As soon as I expand the date range it spins forever then says it can't display the viz. @v-sihou-msft, do we have any control on the amount of RAM available for our project in the cloud?

v-sihou-msft
Employee
Employee

@osinquinvdm

 

I never encountered this "out of memory" issue and crash. If you can't get any valuable information from trace log, I suggest you create a support ticket to deep analysis on the memory issue of your .pbix.

 

Regards,

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.