Memory issue in report builder while running a query

[Dhinesh]

Hi,

I am trying to create a paginated report in report builder using power BI dataset as a source. After I added required columns in table visual and run a report in report builder, it shows below error.

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 simplify the query or its calculations, or if using Power BI Premium, you may reach out to your capacity administrator to see if they can increase the per-query memory limit. More details: consumed memory 10240 MB, memory limit 10240 MB. See https://go.microsoft.com/fwlink/?linkid=2159752 to learn more.

Then I tried with power BI Desktop, added many columns in a tabular visuals, it works fine. It didn't work in report builder.

It will be helpful if anyone share any thoughts.

Thanks in advance.

[v-zhangti · Accepted solution]

Hi, @Dhinesh 

The fact that it works in Power BI Desktop does not guarantee the same performance in Report Builder. Paginated reports can be more memory-intensive, especially when dealing with large datasets or complex aggregations. Ensure that your report is designed efficiently for paginated reporting.

Step 1: Review and simplify the query or calculations used in the report.

Optimization guide for Power BI - Power BI | Microsoft Learn

Step 2: Contact your Power BI Premium capacity administrator to discuss increasing the memory limit if applicable. 

Manage Microsoft Power BI Premium capacities - Power BI | Microsoft Learn
Step 3: Optimize the report by removing unnecessary elements and using filters.

Step 4: If the issue persists, consider breaking the report into smaller, more manageable parts.

Best Regards,

Community Support Team _Charlotte

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