Hello All:
Hoping that one of you can help me understand the memory consumption on Power BI model.
My model is about 6 Gbs on Power BI desktop. My laptop has 64GBs for memory.
One of the report visual gives me an error “There is not sufficient memory for this visual. Please try again when more memory is available”.
I tracked the memory usage on my laptop using Task Manager and the memory usage showed about 15Gbs and then the message pops up.
Questions: (a) Why is Power BI not addressing the maximum memory of 64Gbs? (b) Is there some parameters in Power BI that I need to change and is so which ones? (c) Could there be some physical issue with the computer ? Thanking in advance for your help.
Best regards…Adi
1 Like
What does your data look like?
Hello Deron (kaDargo):
Thanks for your note. It is Patient Claims data over a 5 year period with about 500 million rows. The Patient lookup table (masked) is about 26 million rows…hence the cardinality is very high. The 500 million row tables has 14 numerical columns and 2 textual columns. The text values in both of them is small and low and low cardinality. Thanking you in advance for any help.
Best regards…Adi
1 Like
Bumping this post for more visibility from our experts and users.
Hi @Adi
We noticed that your inquiry was left unsolved for quite some time now.
Looks like your inquiry was out of the experts and users’ bounds.
If you were sure you provided all pertinent context to your concerns and read how to use the forum more effectively and still find your question unanswered, your membership also comes with relevant resources that may help you with your Power BI education, so we advise that you check these resources as well.
While our users and experts do as much as reasonable to help you with your inquiries, not all concerns can be attended to especially if there are some learnings to be done. Thank you!
@Adi It may be caused by the data model being too bloated(large data model , complex queries…) and low local machine configuration.
Please kindly check how much RAM and CPU Power BI is taking. And refer the official document to optimize the data model.
Hello Pooja:
Thanks for the tips. Will review the document you shared the link with.
Yes, I know my model is large due to large datafiles and high cardinality of one of the dimensions. In the task manager it shows that the Power BI consumed about 15 GBs and then gave an error; whereas my machine is 64GB for RAM.
Thanks for your thoughts.
Best regards…Adi