Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Solved! Go to Solution.
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.
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.
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.
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.
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |