This query uses more memory than the configured limit - Would like to see more details

[cherylyu]

One of our reports on PowerBI.com failed to load and gave the below error. However, if I download it and run in PBI Desktop, it works fine. If I save it to a different name and publish it back to the same workspace, it works fine.

Does that make sense? What could be the reason for the initial report to encounter the error?

-------------

More details: Resource Governing: This query uses more memory than the configured limit. The query — or calculations referenced by it — might be too memory-intensive to run. Either reach out to your Analysis Services server administrator to increase the per-query memory limit or optimize the query so it consumes less memory. More details: consumed memory 1024 MB, memory limit 1024 MB.
Activity ID: cd99e50c-e4ea-4248-845a-4e3ffd3695b1
Correlation ID: 0a70106f-fc8f-858c-bc14-42d6beec0bec
Request ID: ae729bdd-01ab-9517-0fe1-1edd20dbf792
Time: Wed Oct 05 2022 18:40:49 GMT-0400 (Eastern Daylight Time)
Service version: 13.0.19183.51
Client version: 2209.4.13431-train
Cluster URI: https://wabi-us-north-central-redirect.analysis.windows.net/

[v-xiaoyan-msft]

Hi @cherylyu ,

According to the official Microsoft article description：

• Report interactions will execute DAX queries. Each DAX query consumes a certain amount of temporary memory required to produce the results. Each query may consume a different amount of memory and will be subject to the query memory limitation as described.

The reason for this problem is the lack of capacity.
If you are not considering purchasing additional capacity, you can refer to the following link to see how to optimize your Power BI reports.

Optimizing Power BI Reports | phData

Best Regards,
Community Support Team _ Caitlyn

[cherylyu]

However, isn't it surprising simply download it, then publish it again will make it work?