Forum Discussion
1GB Limit Explained
Just to expand and clarify on Q1.
When you click "close and apply" the data is stored in RAM. When you click SAVE to save your pbix file the data from RAM is written into the .pbix file (and conversely loading a PBIX reads the all data from disk and loads it into RAM). Technically you will also see some temp files used when you click "close and apply", but those are never permanently stored anywhere.
Note that the size of the data stored inside the pbix file is likely to be slightly smaller than the memory footprint as there are some objects like dictionaries that are stored uncompressed in memory, but have additional compression applied when writing them to disk. And your pbix includes the metadata for your report visuals (the blog Frank linked to breaks down the structure of a pbix file).
> For instance, i recently pubclihsed a PBIX file less then 1GB, yet i got a Memory Exceeded limit error on a single visuailiation
This could be a different memory limit. From memory I think they have some sort of "per query" memory limit on the service to prevent a single visual from consuming too much memory. It's possible that you may have one or more measures that due to the way they are coded need to create materialized temp tables.
Marco Russo did a great demo on using DAX Studio to capture and tune slow running queries here https://www.youtube.com/watch?v=B-h3Pohtn1Y you could use the same technique, but keep an eye on Task Manager to get a rough idea of how much memory your query uses (Marco does show this during his video)
HI d_gosbell
Yes, the visual was consuming too much memory ad an individual query.
This was due to using a SUMX in a way that made it consume too much data, especially as the SUMX works on a row by row basis. Full details if interested here:
https://community.powerbi.com/t5/Desktop/SUMX-Too-Slow-Solution-is-SUMMARIZE/m-p/627654#M299865
Resolved this by using SUMMARIZE.
I will be certain to view the below video so big thank you for sharing! i saw that floating around and its time i view it.
Laz