Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
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]))
What are the usual cause of memories issues?
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?
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,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |