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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

running out of resources

I have a line chart visual of several metrics where I am trying to report their 7 day rolling average. The visual is slow but renders in Power BI desktop but when I publish and view from the web I get an error that I have exceeded the memory resource allocation. Do you have any suggestions on how to break up or optimize measures that require significant resources to compute?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @Anonymous ,

 

Please refer to the following posts to optimize measures.

Solved: Past 3 month rolling average using a measure - Microsoft Power BI Community

Solved: Optimizing 12m rolling average - Microsoft Power BI Community

Solved: How to optimize measures to make it load faster? - Microsoft Power BI Community

 

Or you can get acquainted with DAX Studio.  Use Performance Analyzer in Power BI Desktop to harvest the query produced by your offending visual and then analyze the query's plan in DAX Studio.

 

In addition, you can refer to the following documentation to optimize the data model or environment to optimize performance.

Optimization guide for Power BI - Power BI | Microsoft Learn

Best practice rules to improve your model’s performance | Microsoft Power BI Blog | Microsoft Power BI

How to Optimize Power BI Reports: Power BI Best Practices | by MAQ Software | MAQ Software | Medium

 

Best Regards,

Neeko Tang

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

1 REPLY 1
Anonymous
Not applicable

Hi @Anonymous ,

 

Please refer to the following posts to optimize measures.

Solved: Past 3 month rolling average using a measure - Microsoft Power BI Community

Solved: Optimizing 12m rolling average - Microsoft Power BI Community

Solved: How to optimize measures to make it load faster? - Microsoft Power BI Community

 

Or you can get acquainted with DAX Studio.  Use Performance Analyzer in Power BI Desktop to harvest the query produced by your offending visual and then analyze the query's plan in DAX Studio.

 

In addition, you can refer to the following documentation to optimize the data model or environment to optimize performance.

Optimization guide for Power BI - Power BI | Microsoft Learn

Best practice rules to improve your model’s performance | Microsoft Power BI Blog | Microsoft Power BI

How to Optimize Power BI Reports: Power BI Best Practices | by MAQ Software | MAQ Software | Medium

 

Best Regards,

Neeko Tang

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.