rsQueryMemoryLimitExceeded Error – Consumed Memory 1024 MB, Limit 1024 MB

[Akashkokne1023]

Hi Community,

I am encountering the following error while viewing a report in Power BI Service:

I would like to understand:

1. How can I identify the specific visual, DAX measure, or query causing this memory consumption?
2. Are there recommended approaches to troubleshoot and optimize the report/model?
3. Is this limit fixed at 1024 MB for my capacity, or can it be increased?
4. Which tools (Performance Analyzer, DAX Studio, Log Analytics, etc.) would be most effective for diagnosing this issue?

Any guidance or best practices would be greatly appreciated.

[v-sathmakuri]

Hi  @Akashkokne1023 ,

Could you please review the suggestion provided above and let us know if you still have any further questions?

Thanks!!

[v-sathmakuri]

Hi @Akashkokne1023 ,

Could you please check the provided solution and let us know if you have any further questions.

Thanks!!

[Akashkokne1023]

Thank you!

[rohit1991 · Accepted solution]

Hii @Akashkokne1023 

Use Performance Analyzer to identify the failing visual, copy its DAX query, and test it in DAX Studio with Server Timings/Query Plan; Log Analytics or Workspace Monitoring can provide query-level execution details