Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @cherylyu ,
According to the official Microsoft article description:
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