Memory usage

Ker 20

How do I minimize memory usage of power bi? Is using left join function affecting it?

This question is related to the following Learning Module

Syed Saleem Peera 6,410 Reputation points Microsoft Vendor

2024-09-21T07:38:54.2233333+00:00

Hi Ker,

Thank you for reaching out to us on the Microsoft Q&A forum.

Could you please specify the exact location where you are encountering this error and provide a screenshot for reference?
Ker 20 Reputation points

2024-09-21T11:36:26.59+00:00

Hi thank you for clarifying, the error goes like this:

Now I am not sure if this is the result of using joins on 4 tables, the codes I have used or the laptop I am using is the problem due to its low memory capacity. Can this be compensated by adjusting the sql code or I need to upgrade the laptop itself? (I do not have the codes with me since I am doing coding on company laptop) thank you.

Accepted answer

Syed Saleem Peera 6,410 Reputation points Microsoft Vendor

2024-09-23T03:26:42.8833333+00:00

Hi Ker,

Thank you for reaching out to us on the Microsoft Q&A forum.

To minimize memory usage in Power BI, reduce the number of columns/rows loaded, filter data at the source, avoid calculated columns, optimize joins (prefer inner joins), use aggregations, disable Auto Date/Time, and limit complex visuals.

If the information is helpful, please Accept Answer and Upvote so that it would be helpful to community members.

Thank you.
Please sign in to rate this answer.
Syed Saleem Peera 6,410 Reputation points Microsoft Vendor

2024-09-23T10:01:57.14+00:00

Hi Ker,

Glad to hear that your issue got resolved. Please don't hesitate to reach out to us if you have any further queries.

Thank you.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

1 additional answer

Olaf Helper 44,816 Reputation points

2024-09-21T09:01:36.6+00:00

How do I minimize memory usage of power bi?

Power BI is an "In-Memory-Engine"; it highly uses memory, that's by design, so what do you expect here?

If you want to have lower memory usage on your machine, then stop using Power BI; it uses much memory = RAM.
Please sign in to rate this answer.
Ker 20 Reputation points

2024-09-21T11:33:00.24+00:00

Ow I am sorry for this confusing question, what I do want to ask is during refresh I am encountering memory issue on power bi. I am guessing that it may be because I used around 4 joins on my query. Sorry just a beginner. The error is just like this

Cant retrieve the exact codes since the laptop I used was company laptop. Thank you for support and sorry for the inconvenience.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Your answer