Share via

Memory usage

Ker 20 Reputation points
2024-09-21T07:23:26.6766667+00:00

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

Community Center Not monitored
Accepted answer
  1. Syed Saleem Peera 13,060 Reputation points Microsoft External Staff Volunteer Moderator
    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.

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 47,436 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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.