running out of resources

[granvilj]

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?

[v-tangjie-msft · Accepted solution]

Hi @granvilj ,

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 ...

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.