Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to configure Power BI Desktop to use more memory

I have been lucky enough to have an upgraded computer with 64 GB of memory.  While working in Power BI Desktop I am experiencing some wait times when creating measures and calculated columns.  I have looked at posts related to optimizing my PBIX structure, but I am trying to see how I can more fully leverage the computer resources available. 

 

Task manager is showing that Power BI Desktop is using less than 4 GB of RAM when the computer has LOTS of RAM headroom.  Is there some way that I can increase the RAM used by Power BI Desktop to more fully utilize the resources this computer has?

1 ACCEPTED SOLUTION
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

It’s my pleasure to answer for you.

According to your description,A computer with 64G memory is generally enough if the amount of data is not large.If you feel that PBI runs slowly after creating measure or column, it may be that your formula has used too many iterations or repeated calculations.

You can use DAX studio or PBI preformance analyzer to monitor duration.

Here are some links about DAX optimization.

https://maqsoftware.com/expertise/powerbi/dax-best-practices

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-janeyg-msft
Community Support
Community Support

Hi, @Anonymous 

 

It’s my pleasure to answer for you.

According to your description,A computer with 64G memory is generally enough if the amount of data is not large.If you feel that PBI runs slowly after creating measure or column, it may be that your formula has used too many iterations or repeated calculations.

You can use DAX studio or PBI preformance analyzer to monitor duration.

Here are some links about DAX optimization.

https://maqsoftware.com/expertise/powerbi/dax-best-practices

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-performance-analyzer

If it doesn’t solve your problem, please feel free to ask me.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Thanks - I am new to DAX Studio.  This sounds like I can paste in each measure/calculated column and get a analysis for that query.  I have about 45 measures.  Is there a way to identify the highest cost ones first?

 

My adopted PBI file has My Data Cache Management Options is showing 3.65 GB currently used.  I doubled the Maximum allowed (MB) to new value of 8192.

lbendlin
Super User
Super User

Power BI will eat up all the memory if it needs it.   Most likely your issue is with the number of compute loops, not with memory. Use DAX Studio to check your query and measure performance.

 

You can check/modify the Global Data Load settings to see if you are maxing out the cache or not.

lbendlin_0-1604503138285.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.